Hi James
You forgot to post your formula but just for your information;
If your start time is A1 (11:00pm), end time in B1 ( 7:00am, try this,
=MOD(B1-A1,1) format cell Custom [h]:mm
HTH
Regards
John
"James Harris" wrote in message ...
I have a similar issue where I need to calculate hours worked between 11pm
and 7am for a shift differential. I am not sure how to modify the formula
below to make it work. If anyone has a solution or suggection on how to go
about this, please let me know.