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

=(F16/1440)/60

And a custom cell format m:ss


By the way, be careful with F16's.
Sometimes they'll come down.



"GTVT06" schreef in bericht
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

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

or:

=TEXT(((F16/1440)/60);"m:ss")


"moon" schreef in bericht
. ..


=(F16/1440)/60

And a custom cell format m:ss


By the way, be careful with F16's.
Sometimes they'll come down.



"GTVT06" schreef in bericht
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