Convert seconds to h:mm

  • Thread starter Thread starter GTVT06
  • Start date Start date
G

GTVT06

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.
 
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)
 
Back
Top