Converting a total number of minutes to hours and Minutes

Rick Rothstein wrote:

Try dividing the 115 minutes by 1440 (number of minutes in a day) and then format the cell however you want. For example, h:mm or h.mm or any other way you might want.

nikhilanand31 wrote:

i hav 2480 minutes. i applied your suggestion but it not works on it correctly. 

Use the Custom format [h]:mm or [h].mm.

The notation [h] ensures that total hours are formatted, not just hours modulo 24.  For example, you will see 41.20 instead of 17.20.

If, instead, you would like to days, hours and minutes in some form, you might get away with the Custom format d hh:mm without the double-backquotes, or even [>=1]d hh:mm;h:mm.

But that works only for less than 32 days because "d" is really day of the month, not elapsed days.  32 days looks like 1 Feb; so "d" would format as 1, not 32.

gayle.a wrote:

MINUTES             =SUM(H2/60)     =TIME(0,H2,0) formatted as [h];mm..why the 0 before and after H2 in this formula?

  27000                       450.00                18:00

                                   correct               WRONG

                                   decimal # .. how do I make it read 450:00??

Replace =TIME(0,H2,0) with =H2/24 formatted as Custom [h]:mm.

Alternatively, replace =H2/60 (you do not need to use SUM) with =H2/60/24 or =H2/1440 formatted as [h]:mm.

With Excel time values, the integer portion is a number of days, and the decimal fraction is the remaining time (fraction of a day).

The TIME function returns only the time portion -- the decimal fraction.

As in above question: I have a column of MINUTES (H2) that I want to convert to HOURS:MINUTES.. (NOT a time of day)

I tried your example above 115/1440 and formatted h:mm ...and it DID return desired result of 1:55.  But when that time exceeds 24 hours .. it did not work:

my columns & formulas read like this:

MINUTES             =SUM(H2/60)     =TIME(0,H2,0) formatted as [h];mm..why the 0 before and after H2 in this formula?

  27000                       450.00                18:00

                                   correct               WRONG

                                   decimal # .. how do I make it read 450:00??

what am I doing wrong?