G
grandma
I want to change minutes to hours as a function. How?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
R
Ragdyer
I believe Dave might have meant:
=A1/60
=A1/60
G
Gord Dibben
Ya beat me to it, but I was waiting for Dave to pick it up<g>
Gord
Gord
D
Dave Peterson
I actually didn't.
But maybe I misinterpreted.
If I have 00:01:30 (90 seconds), but I made a mistake during data entry--I
really wanted 01:30:00 (90 minutes), I'd multiply by 60.
But maybe I misinterpreted.
If I have 00:01:30 (90 seconds), but I made a mistake during data entry--I
really wanted 01:30:00 (90 minutes), I'd multiply by 60.
I believe Dave might have meant:
=A1/60
G
Gord Dibben
"I want to change minutes to hours"
That looks to me like A1 in minutes should be divided by 60 to convert to hours.
300 minutes/60 returns 5 hours.
Guess we'll have to wait for OP to respond.
Gord
That looks to me like A1 in minutes should be divided by 60 to convert to hours.
300 minutes/60 returns 5 hours.
Guess we'll have to wait for OP to respond.
Gord
I actually didn't.
But maybe I misinterpreted.
If I have 00:01:30 (90 seconds), but I made a mistake during data entry--I
really wanted 01:30:00 (90 minutes), I'd multiply by 60.
D
Dave Peterson
The more obvious explanation <bg>.
Gord said:"I want to change minutes to hours"
That looks to me like A1 in minutes should be divided by 60 to convert to hours.
300 minutes/60 returns 5 hours.
Guess we'll have to wait for OP to respond.
Gord