Converting military time minutes to hundreths for accounting

  • Thread starter Thread starter JD Fields
  • Start date Start date
J

JD Fields

I am trying to come up with a formula for work that has
time in, time out, and total hours but the total hours
need to be converted into hundreths for accounting.
time in time out total hours
12:00 14:15 2.25 hours

somebody please help!!
 
I am trying to come up with a formula for work that has
time in, time out, and total hours but the total hours
need to be converted into hundreths for accounting.
time in time out total hours
12:00 14:15 2.25 hours

somebody please help!!
Click to expand...

=(TimeOut-TimeIn)*24

will work for examples similar to what you posted. However, if your time span
passes midnight, then this formula will fail.

If that is the case, the most foolproof option would be to include the date
along with the time, but other options are possible depending on the possible
time frames.

For example, if the maximum time span will be less than 24 hours, you could
use:

=(TimeOut-TimeIn+(TimeOut<TimeIn))*24


--ron
 
Back
Top