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

=HOUR(A1)+MINUTE(A1)/60

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.

0 comments:

Post a Comment