Convert hours to time

An excel formula to convert hours to time

Sponsored Link

 Convert hours to time
=hours/24

To convert hours in decimal format to a value Excel recognizes as time, divide by 24. 

In the example shown the formula in C5 is:

 
=B5/24

which returns 0.5, the equivalent of 12 hours.

How this formula works

In the Excel date system, one day is equal to 1. Since there are 24 hours in a day, you need to divide by 24 in order to convert to a value that Excel will recognize as time. After the conversion, you can apply a time format of your choice, or use the result in a math operation with other dates or times.

In the example, since B5 contains 12 (representing 12 hours) the result is 12/24 = 0.5, since there are 12 hours in a half of day.

To see the result formatted as time, apply a time format.

Durations longer than 24 hours

To display hours that represent a duration longer than 24 hours, you'll need to adjust the number format. Just wrap the h in square brackets like so:

 
[h]:mm

To display in minutes, you can do the same thing with m:

 
[m]

The brackets tell Excel the time is a duration, and not a time of day.

Sponsored Link

0 votes. 0 / 5