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
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