Solved changing an excel file from 00:00:00 to 0.0 but keeping the

October 2, 2013 at 06:33:38
Specs: Windows 7
Excel problems
changing an excel file from 00:00:00 to 0.0 but keeping the same values

what excel formula do i use to change 00:00:00 into identical 0.0 format

e.g.

The engine vehicle time is 32:17:33 (HH:MM:SS) however i just need it to transform into 32.17
I've tried formatting and [H].m which has changed it however when i add to it or auto sum it, it gives me an incorrect answer.

Please help


See More: changing an excel file from 00:00:00 to 0.0 but keeping the

Report •

#1
October 2, 2013 at 07:45:24
✔ Best Answer
What you are trying to do is essentially incorrect.

The reason I say that is because 32.17 hours is not the same amount of time as 32 hours and 17 minutes. 32:17 = 32.28333

Decimals are based on a range of 0 - 100, while minutes are based on 0 - 60. Excel has no way of knowing the 32.17 is a time and that the .17 is 17 out of 60.

If you want to convert your times to decimal, that's fine, but you shouldn't do it the way you are. See this information at this site:

http://office.microsoft.com/en-us/e...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question