Converting Times to Decimal Values

[ExcelTip]

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)

[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

http://www.mrexcel.com/archive/Dates/632.html