» Converting Times to Decimal Values
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
Recommended Books:
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
