In the minor modification I had to check for '0' time because of days not
worked. If I didn't I would get 24 hours worked.
=IF(endtimestartime,endtime-startime,IF(startime0,(startime+24)-endtime,0))

"maintchief" wrote:

That pluse a minor modification to make sure the time had an entry did the
trick.
Thank you

"Gary''s Student" wrote:

How about

=if(endtimestartime, endtime-startime,(endtime+24.0)-startime)
--
Gary's Student


"maintchief" wrote:

Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
do I calculate it correctly since I can't just subtract the end time from the
start time as I do for same day start and stop times?