» 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:

Excel VBA books
Accounting books
Business Plans
MS Office books
Taxes books

VIEW ALL BOOKS

Recommended Books:

Learn MS Excel 2002 VBA/XML Programming
Windows XP Pocket Reference
The New Financial Order: Risk in the Twenty-First Century
Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
Special Edition Using Microsoft Access 2002

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 4.18 Views: 18333

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]

» Converting Times to Decimal Values

Book Store:

Recommended Books:

For Registered Users

For Guest