Convert minutes to time

An excel formula to convert minutes to time

Sponsored Link

 Convert minutes to time
=minutes/1440

To convert minutes in decimal format to a proper Excel time, divide by 1440.

In the example shown, the formula in C5 is:

 
=B5/1440

Because B5 contains 360 (representing 360 minutes) the result is 360/1440 = 0.25, since 360 minutes = 6 hours = 1/4 day.

To display the result as time, apply a time format.

How this formula works

In the Excel date system, one day is equal to 1. This means 1 hour = 1/24, since there are 24 hours in a day. To get the equivalent of 1 minute, we need to divide by 1440, since there are 1440 minutes in a day (24 x 60).

In the example, since B5 contains 360 (representing 6 hours) the result is 360/1440 = 0.25, since 6 hours = 1/4 day.

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

Durations

To display hours that represent a duration longer than 24 hours, or minutes in durations longer than 60 minutes, you'll need to adjust the number format by adding square brackets.

 
[h]:mm // hours > 24 [m] // minutes > 60

The brackets signal to Excel that the time is a duration, and not a time of day.

Sponsored Link

0 votes. 0 / 5