Time Formula

[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

 

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