Time Formula

G

Guest

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)
 

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

Time In-Time Out/No. of Units 10
Subtracting time...again 2
Decimal to Time Format. 5
Convert Decimal hours and Minutes to minutes please. 13
Countifs with different restrictions 1
military time set up 6
Time Calculated minus breaks & lunch 2
Calculate time with a break and total hours 5

Top