Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert seconds to h:mm
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to convert Minutes:Seconds format to minutes with seconds con | Excel Worksheet Functions | |||
How do I convert 1min and 15 seconds to all seconds | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
convert seconds to minutes and seconds | Excel Worksheet Functions |