|  

» Converting Times to Decimal Values

CATEGORY - Excel Date & Time Formulas VERSION - All Microsoft Excel Versions
Problem:

Converting the time values ("hh:mm") in column A to their decimal equivalents.

Solution:

Use the HOUR and MINUTE functions as shown in the following formula:
=HOUR(A2)+(MINUTE(A2)/60)


Book Store:

VIEW ALL BOOKS

Recommended Books:

Print Tip
Add to My Tips
Rate This Tip
12 34 5
Rating: 4.18     Views: 18487
converting time (over 24 hours) to decimal
jodyk
I used the formula for converting time into a decimal and that worked great until I have a time that's over 24 hours. For example 25:30. How can you get the formula to work with a time value over 24 hours?

Thanks, Jody
oldchippy
Take a look here for an alternative

[url]http://www.mrexcel.com/archive/Dates/632.html[/url]
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments


Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation