|  

» Converting a Decimal Value to a Time Value

Problem:
Converting the decimal values in column A to correctly formatted time values.

Solution:

Divide each number by 24 as follows:
=A2/24
Format your result cells as custom "[hh]:mm".

Rate This Tip
12 34 5
Rating: 3.09     Views: 61517
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments