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?
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?