Converting military time minutes to hundreths for accounting

[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!!

 

[David McRitchie]

=24*(B2-A2) format as a number

or if time can go through midnight (but under 24 hours elapsed)
=24*( B2-A2 + (A2>B2) )

Dates are days past Dec 31, 1899 and Time is fractional days.

Additional reference:
http://www.mvps.org/dmcritchie/excel/datetime.htm

 

[Ron Rosenfeld]

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

=(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