Microsoft KB Archive/47580

{|
 * width="100%"|

Excel: Converting Time (h:mm) to Decimal (0.00 Hours)

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

-

SUMMARY
The following formula converts time from the &quot;hour:minute&quot; format to a decimal equivalent in Microsoft Excel:

  =(Time-INT(Time))*24

&quot;Time&quot; is the number you want to convert from colon format to decimal. It can be a cell reference or a string of numbers.

For example, if you have &quot;4:30&quot; representing four hours and 30 minutes in A1, the formula would read as follows:

  =(A1-INT(A1))*24

The result is &quot;4.5&quot;.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :