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?

 

[Rick Rothstein]

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

If C8 is formatted as [m], that means its contained value is 6:25. You can put this formula in cell C9...

=C8

and then format the cell as [h]:mm

 

[mayoung]

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

That worked

 

[mayoung]

If C8 is formatted as [m], that means its contained value is 6:25. You can put this formula in cell C9...

=C8

and then format the cell as [h]:mm

That worked. Something so simple.

 

[mayoung]

That worked. Something so simple.

I have a question if I take 385 minutes and divide by 60 it comes up

If C8 is formatted as [m], that means its contained value is 6:25. You can put this formula in cell C9...

=C8

and then format the cell as [h]:mm

i have a question if you take 385 minutes and divide by 60 (60 minutes in an hour) it comes up as 6.41666667 should that be 6.42 instead of 6.25?

I am confused? Please help me understand?

 

[fhqwgads]

i have a question if you take 385 minutes and divide by 60 (60 minutes in an hour) it comes up as 6.41666667 should that be 6.42 instead of 6.25?

6.42 hours
.42 of an hour is 25 minutes
the format h:mm gives hours and minutes so 6:25 is 6 hours and 25 minutes
if you formatted as only hours it would show 6.42

 

[mayoung]

6.42 hours
.42 of an hour is 25 minutes
the format h:mm gives hours and minutes so 6:25 is 6 hours and 25 minutes
if you formatted as only hours it would show 6.42

Which is [h] ?

 

[Rick Rothstein]

The .41666667 is not minutes... it is the fraction of an hour left over once you obtain your 6 full hours. If you multiply 60 times .41666667 you get 25.

 

[fhqwgads]

actually wait sorry i was wrong
formatting as hours [h] will just give you 6
i'm not sure how to get the .42 with just formatting

 

[mayoung]

The .41666667 is not minutes... it is the fraction of an hour left over once you obtain your 6 full hours. If you multiply 60 times .41666667 you get 25.

So nothing in will come up with the 6.42 then? Using the 385 as minutes?

 

[fhqwgads]

in C9 try
=C8*24
and format it as general or 0.00