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?