Team,
I need help in excel sheet, i have different start timing and end timing, but the frequency of the timing is fixed for 3 hours windows from 6AM until 6PM. I need to identify the start and end time is falls under which category like A, B, C. D or E.
If the timing is between row A and B then system should identify the large time and select the Row.
Below is the sample sheet.
Regards, Atif
I need help in excel sheet, i have different start timing and end timing, but the frequency of the timing is fixed for 3 hours windows from 6AM until 6PM. I need to identify the start and end time is falls under which category like A, B, C. D or E.
If the timing is between row A and B then system should identify the large time and select the Row.
Below is the sample sheet.
| A | B | C | D | E | Start time | End time | Category |
| 6:00:00 AM | 9:00:00 AM | 12:00:00 PM | 3:00:00 PM | 6:00:00 PM | 5:37:14 AM | 5:47:29 AM | |
| 9:00:00 AM | 12:00:00 PM | 3:00:00 PM | 6:00:00 PM | 6:00:00 AM | 5:51:19 AM | 6:42:08 AM | |
5:53:05 AM | 7:04:34 AM | ||||||
6:04:41 AM | 6:13:02 AM | ||||||
6:07:02 AM | 7:07:04 AM | ||||||
6:07:30 AM | 6:59:14 PM | ||||||
6:12:03 AM | 6:15:38 AM | ||||||
6:14:16 AM | 6:20:41 AM | ||||||
6:15:11 AM | 6:45:21 AM | ||||||
6:15:41 AM | 11:21:52 AM | ||||||
6:17:22 AM | 3:41:20 PM | ||||||
6:20:09 AM | 6:47:11 AM | ||||||
6:20:51 AM | 6:50:41 AM | ||||||
6:23:45 AM | 6:29:19 AM | ||||||
6:24:42 AM | 6:48:44 AM | ||||||
6:25:35 AM | 6:28:56 AM | ||||||
6:30:32 AM | 6:43:27 AM |
Regards, Atif
