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:

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:

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

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