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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
That pluse a minor modification to make sure the time had an entry did the
trick.
Thank you
 
You are welcome. If you get the chance, post your minor mode, it may be of
help to others.
 
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))
 
Back
Top