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?