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

Getting to Yes: Negotiating Agreement Without Giving In
Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
Learn MS Excel 2002 VBA/XML Programming
Windows XP Pocket Reference
Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
Treason: Liberal Treachery from the Cold War to the War on Terrorism

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 4.18 Views: 19838

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