Convert seconds to h:mm
That returns 2:30 for me, but all you need is
=H17/60/24
and format as time.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"GTVT06" wrote in message
oups.com...
Hello, I'm trying to convert seconds to h:mm format which will make it
appear as mm:ss
H17 has a value of 150 formated as a number. but it represents 150
seconds. The actual value I'm trying to get is 2:30 so that it appears
as 2mins and 30seconds rather than 150 seconds.
I have a formula in cell F16 which returns a value of 2:29 but I was
needing an exact match of 2:30 and it's a second off, so I didn't know
if I was doing something wrong.
The formula I have in F16 is =TEXT(H17/60/24,"H:MM")
Any help is appreciated. Thanks
|