Hi there,
What I am looking for is a formula that will tell me what shift was working when a call was placed based on the time of the call. The shifts are as followed:
7:30-15:30 - Days
15:30-23:30- Afternoon
23:30-7:30- On Call
This is what I have came up with so far:
=+IF(C2>="7:30"<"15:30","Day",IF(C2>="15:30","Afternoon","On Call "))&"Shift"
Here is the data and my results from this formula
<tbody>
</tbody>
As you can tell if the call was placed in the "Day" shift category it is not yielding the correct answer from this formula. Any help is greatly appreciated
Thanks!
What I am looking for is a formula that will tell me what shift was working when a call was placed based on the time of the call. The shifts are as followed:
7:30-15:30 - Days
15:30-23:30- Afternoon
23:30-7:30- On Call
This is what I have came up with so far:
=+IF(C2>="7:30"<"15:30","Day",IF(C2>="15:30","Afternoon","On Call "))&"Shift"
Here is the data and my results from this formula
Time | Column1 |
15:02 | On Call Shift |
15:10 | On Call Shift |
17:53 | AfternoonShift |
23:54 | AfternoonShift |
20:34 | AfternoonShift |
09:12 | On Call Shift |
10:26 | On Call Shift |
10:32 | On Call Shift |
10:28 | On Call Shift |
12:20 | On Call Shift |
13:48 | On Call Shift |
09:18 | On Call Shift |
09:59 | On Call Shift |
11:00 | On Call Shift |
15:21 | On Call Shift |
09:26 | On Call Shift |
03:52 | On Call Shift |
01:27 | On Call Shift |
23:18 | AfternoonShift |
10:58 | On Call Shift |
13:16 | On Call Shift |
14:29 | On Call Shift |
19:05 | AfternoonShift |
15:05 | On Call Shift |
16:17 | AfternoonShift |
21:39 | AfternoonShift |
<tbody>
</tbody>
As you can tell if the call was placed in the "Day" shift category it is not yielding the correct answer from this formula. Any help is greatly appreciated
Thanks!