convert time to decimal

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
 
Y

Yanick

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
 
F

Fred Smith

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

Regards,
Fred
 

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

Convert Decimal fractions to binary and vice versa 1
Decimal to Time Format. 5
convert time to 1/4 hours 2
Convert decimal days to hours and minutes 2
WCG Stats Monday 11 September 2023 2
How to convert time expressed as a decimal to actual hours or minu 8
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
WCG Stats Wednesday 02 August 2023 2

Top