Formula needed to calculate the difference between excel time and decimal time?

0

Hi all

my colleagues have input timesheets onto excel but the time element has been input incorrectly - for example 7 hours and 15 minutes has been put on as 7.15 (ad there maybe should have been a colon in there as opposed to a decimal) - this should actually have been put on as 7.25 because when you multiply the charge rate by 7.15 we are losing 10 minutes of charge to the customer. Is there a way for excel to do a calculation so that even if the time has incorrectly been input as 7.15, the calculation can automatically convert this to a decimal time - i.e. 7.25?

Thoughts gratefuly appreciated

Answer
Discuss

Answers

1
Selected Answer

Use this formula:

=TRUNC(A1)+(A1-TRUNC(A1))*1.66666667

A1 is the cell with the time.

Discuss

Discussion

Don can I say - thank you very much!!!! You REALLY are the DON!

Youve saved me hours of time!!

Many thanks
cookieboy111 (rep: 2) Jul 27, '16 at 11:20 am
Glad to help! :)
don (rep: 1322) Jul 27, '16 at 11:46 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login