Convert decimal minutes to Excel time
Generic formula
=minutes/1440
Related formulas
Convert decimal hours to Excel time
Convert decimal seconds to Excel time
Calculate number of hours between two times
Add decimal hours to time
Add decimal minutes to time
Explanation
To convert minutes in decimal format to a proper Excel time, pide 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 pide 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.