Time Formula

M

mbranstrator

How do I convert a time formula from actual minutes to a decimal (100 units
per hour)?

Example using military time:
13:00 - 8:30 = 4 hours 30 minutes OR 4.50
 
B

Bob Phillips

Just multiply the result by 24 (hours in a day)

=C1*24

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top