How to convert Time (HH:MM:SS) in digitformat

December 16, 2010 at 05:33:35
Specs: Windows XP
How can I convert Time which is in (HH:MM:SS) format to number format.

Example : A1 cell is having 720:00:00 I want this in number format, however I don't want to change the number value. (I want 720.00) not (30.00)

Can anybody help me.

See More: How to convert Time (HH:MM:SS) in digitformat

Report •

December 16, 2010 at 16:35:14
Try this:

With your TIME in cell A1: 720:00:00

First: Format cell B1 as NUMBER
Then in cell B1 enter the formula =A1*24

Should give you 720.00


Report •
Related Solutions

Ask Question