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 "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 :
Technology :
Last Reviewed: March 15, 1999 |