Good Morning,
I am creating a shift resource plan for my company, which would highlight the cells between two 24hr times as shown in the picture below.
ResPlan.PNG
The formula I am currently using is =IF(F1>=$C$4,IF(F2<=$D$4,1,0),0) , this formula currently changes the cell value to '1' if TRUE so my CF can turn the cell green.
Although this only works for shifts that start after 06:00 and finish before 23:59, as you can see from the above picture we have late shifts and night shifts (22:30 - 07:00), currently my formula does not highlight the cells!
Can anyone please please help?
Thanks Mike
Bookmarks