Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
I want to change minutes to hours as a function. How?
-- grandma |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
=a1*60
and format nicely. grandma wrote: I want to change minutes to hours as a function. How? -- grandma -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
I believe Dave might have meant:
=A1/60 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... =a1*60 and format nicely. grandma wrote: I want to change minutes to hours as a function. How? -- grandma -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
Ya beat me to it, but I was waiting for Dave to pick it up<g
Gord On Sun, 4 Mar 2007 17:24:48 -0800, "Ragdyer" wrote: I believe Dave might have meant: =A1/60 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
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. Ragdyer wrote: I believe Dave might have meant: =A1/60 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... =a1*60 and format nicely. grandma wrote: I want to change minutes to hours as a function. How? -- grandma -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
"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 On Sun, 04 Mar 2007 20:22:27 -0600, Dave Peterson wrote: 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. Ragdyer wrote: I believe Dave might have meant: =A1/60 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... =a1*60 and format nicely. grandma wrote: I want to change minutes to hours as a function. How? -- grandma -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel
The more obvious explanation <bg.
Gord Dibben wrote: "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 On Sun, 04 Mar 2007 20:22:27 -0600, Dave Peterson wrote: 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. Ragdyer wrote: I believe Dave might have meant: =A1/60 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... =a1*60 and format nicely. grandma wrote: I want to change minutes to hours as a function. How? -- grandma -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|