Calculating time worked using 100ths of an hour, from 1 day into n

[maintchief]

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?

 

[Gary''s Student]

How about

=if(endtime>startime, endtime-startime,(endtime+24.0)-startime)

 

[maintchief]

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

 

[Gary''s Student]

You are welcome. If you get the chance, post your minor mode, it may be of
help to others.

 

[maintchief]

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(endtime>startime,endtime-startime,IF(startime>0,(startime+24)-endtime,0))