Hi,
I am trying to figure out the formula to conditionally format a cell based on total hours between an end time and a start time.
The formula needs to work between 20:45 & 07:15 for this example, and if the time between them two times is less than 11 hours then format the cell colour to red.
E2 - M Shift ( Cell That Needs Formatting )
U2 - 20:45 ( End Time )
W2 - 07:15 ( Start Time )
Thanks in advance
StokieWorm
Bookmarks