kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 953
- Office Version
- 365
Hi,
I have the following sheet that tracks system downtime at outlets.Column H to U is the business opening and closing hours. I need to tag as Yes or No if the start and end time for downtime is within the business hours of the outlets.
For example, on Feb 19, there is a system downtime in Houston outlet. The downtime started on Saturday Feb 19 at 8.30 pm which is within the business hours of the Houston outlet and therefore should be tagged as Yes.
Is there a formula I can use to automate this ?
Appreciate all the help.
I have the following sheet that tracks system downtime at outlets.Column H to U is the business opening and closing hours. I need to tag as Yes or No if the start and end time for downtime is within the business hours of the outlets.
For example, on Feb 19, there is a system downtime in Houston outlet. The downtime started on Saturday Feb 19 at 8.30 pm which is within the business hours of the Houston outlet and therefore should be tagged as Yes.
Is there a formula I can use to automate this ?
| Excel Workbook | |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
| 1 | * | * | Downtime | Monday | Monday | Tuesday | Tuesday | Wednesday | Wednesday | Thursday | Thursday | Friday | Friday | Saturday | Saturday | Sunday | Sunday | * | |||||
| 2 | Location | Description | Start Date | Start Time | End Date | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Affected | ||
| 3 | MHH Houston Outlet | AS 400 Down | 2/19/2011 | 8.30 PM | 2/19/2011 | 9.30 PM | 9.00 AM | 7.00 PM | 9.00 AM | 7.00 PM | 9.00 AM | 7.00 PM | 9.00 AM | 7.00 PM | 9.00 AM | 10.00 PM | 9.00 AM | 10.00 PM | 9.00 AM | 10.30 PM | Yes | ||
| 4 | MHH Dallas Outlet | AS 400 Down | 2/19/2011 | 11.45 PM | 2/20/2011 | 12.45 AM | 10.00 AM | 10.00 PM | 10.00 AM | 10.00 PM | 10.00 AM | 10.00 PM | 10.00 AM | 10.00 PM | 10.00 AM | 10.30 PM | 10.00 AM | 11.30 PM | 10.00 AM | 11.45 PM | No | ||
| 5 | MHH New York Outlet | AS 400 Down | 2/19/2011 | 11.45 PM | 2/20/2011 | 11.30 AM | 10.00 AM | 10.00 PM | 10.00 AM | 10.00 PM | 10.00 AM | 10.00 PM | 10.00 AM | 10.00 PM | 10.00 AM | 10.30 PM | 10.00 AM | 11.30 PM | 10.00 AM | 11.45 PM | Yes | ||
Downtime | |||||||||||||||||||||||
Appreciate all the help.
