convert time to decimal

  • Thread starter Thread starter doodle302
  • Start date Start date
D

doodle302

I'm looking for a formula to convert time to a decimal

Example: (6:15 + 5:45 + 2:15 + 1:25) * 3 = equals amount due in dollars
(whole number)

times listed are for different days
 
I'm looking for a formula to convert time to a decimal

Example: (6:15 + 5:45 + 2:15 + 1:25) * 3 = equals amount due in dollars
(whole number)

times listed are for different days
Click to expand...

Use cell format [h]:mm:ss

23:00 + 6:00 will = 29:00
 
In Excel, times are fractions of a day. Change your formula to:
(6:15 + 5:45 + 2:15 + 1:25) * 24 * 3

Regards,
Fred
 
Back
Top