|  

» Converting Times to Decimal Values

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)


Rate This Tip
12 34 5
Rating: 4.16     Views: 30084
No comments have been submitted.
Name
Comment Title
Comments