Formula Question h:mm

[mayoung]

Please Help:
In cell C8 is the number 385 which is total minutes per day. I am trying to convert 385 to total hours and minutes in C9 which should come out to
6 hours and 42 minutes. I am using the formula =convert(C8,”mn”,”hr”).
I have cell C9 Custom formatted as h:mm.
The answer in C9 comes up as 0:06

What am I doing wrong? I want to show hours and minutes?

 

[harveya915]

Shouldn't "hr" be first than "mn"?

 

[mayoung]

Shouldn't "hr" be first than "mn"?

harveya915
I have tried switching them around like you suggested but it comes back as 1:00?

 

[Rick Rothstein]

Shouldn't 385 minutes convert to 6 hours and 25 minutes?

You have two choices depending on if you want a real time value or text.

Real: =C8/1440 and format the cell [h]:mm

Text: =TEXT(C8/1440,"[h]:mm")

 

[fhqwgads]

"mn" first should be correct

CONVERT function - Microsoft Support

Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

support.microsoft.com

CONVERT(number,from_unit,to_unit)

but when i use it i get 10:00 for some reason instead of 0:06

in any case i dont think using CONVERT will be able to give you hours and minutes
you can try use
=QUOTIENT(C8,60)&":"&MOD(C8,60)
which should give you 6:25

 

[mayoung]

Shouldn't 385 minutes convert to 6 hours and 25 minutes?

You have two choices depending on if you want a real time value or text.

Real: =C8/1440 and format the cell [h]:mm

Text: =TEXT(C8/1440,"[h]:mm")

Rick,

I have tried both formulas and both return as 0.00?

Cell C8 is formatted as minutes [m] does this matter?

 

[fhqwgads]

Cell C8 is formatted as minutes [m]

if C8 is formatted as minutes and displays 385 you should just be able to apply h:mm format to C8 to get 6:25

 

[mayoung]

"mn" first should be correct

CONVERT function - Microsoft Support

Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.

support.microsoft.com

but when i use it i get 10:00 for some reason instead of 0:06

View attachment 20634

in any case i dont think using CONVERT will be able to give you hours and minutes
you can try use
=QUOTIENT(C8,60)&":"&MOD(C8,60)
which should give you 6:25

Thank You for also replying but when I use your formula I get an error There’s a problem with this formula?

 

[mayoung]

if C8 is formatted as minutes and displays 385 you should just be able to apply h:mm format to C8 to get 6:25

But I need C9 to give me the 6:25 and leave cell C8 as 385?

 

[fhqwgads]

But I need C9 to give me the 6:25 and leave cell C8 as 385?

in C9 just put =C8 and format the cell with h:mm