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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i operate on the decimal portion of a number 3
Calculate the difference between two times 3
Time Calculated minus breaks & lunch 2
Time in calculated field for shifts going past midnight 0
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL 1
calculate time elapsed inbetween days 3
Calculate hour and minutes worked each day 3
24 Hour Clock Calculations 1

Back
Top