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

ID: Q47580

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 "hour:minute" format to a decimal equivalent in Microsoft Excel:


   =(Time-INT(Time))*24

"Time" 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 "4:30" representing four hours and 30 minutes in A1, the formula would read as follows:


   =(A1-INT(A1))*24

The result is "4.5".

Additional query words:


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 15, 1999