In the example, since B11 contains 720 (representing 720 minutes) the result is 720/1440 = 0.5.
Once a time format like h:mm has been applied, Excel will display 12:00.
The brackets signal to Excel that the time is a duration, and not a time of day.
Convert decimal minutes to Excel time
To convert minutes in decimal format to a proper Excel time, divide by 1440. In the example shown, the formula in C6 is: =B6/1440 Because B6 contains 60 (representing 360 minutes) the result is 60/1440 = 0.04167, since 60 minutes = 1 hour = 1/24 day. Cell D6 shows the same result formatted as time, which displays 1:00.
