| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert seconds to hh:mm:ss.dd ?
Could someone help me derive a formula that will turn a column of
seconds and decimals into hours, mins, secs, decimals please. For example: Original New -------- --------- 92.16 00:01:32.16 3987.65 01:06:27.65 I can get there with several columns, and I suppose I could manipulate these and get them into a single column, but I'm sure there must be a more elegant solution? -- Terry, West Sussex, UK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert seconds (up to 38,000) into HR:MN:SEC? | Excel Discussion (Misc queries) | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| Convert seconds to minutes and seconds in excel | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
