Time difference

[Jenny]

Hi there,
I have a spreadsheet which compares start and finish
times, to rostered start and finish times. From this I
use conditional formatting to highlight the cells if the
time difference is greater than the rostered hours =($B$1-
$A$1)>($E$1-$D$1).
This works really great except for a group where their
rostered hours finish at 24:00. If they work past their
finish time, the calculation does not work. I can't just
stipulate that the time is different from the rostered
hours as I don't want the cells to highlight if they have
worked less than their rostered hours.
Is there another way I can do this?
Thanks

 

[Frank Kabel]

Hi
try the formula
=($B$1-$A$1+($B$1<$A$1))>($E$1-$D$1+($E$1<$D$1))

 

[Jenny]

Thanks Frank
Really appreciate your help.

-----Original Message-----
Hi
try the formula
=($B$1-$A$1+($B$1<$A$1))>($E$1-$D$1+($E$1<$D$1))

--
Regards
Frank Kabel
Frankfurt, Germany


.