Thursday, September 1, 2011

Converting EXCEL time format to DECIMAL

How to convert EXCEL time format to a DECIMAL format? Like, did you mean like 5:30 into 5.50?

First type 5:30 into cell A1
Then in B1 put this formula


if it says 12:00 then change the format to number.

Right click first the cell B1
Choose Format cells...
Change it to Number

The output should be 5:30

Then your TIME format has changed into DECIMAL format now.

Hope it helps.


Post a Comment