| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert seconds to hh:mm:ss.dd ?
=A1/(24*60*60)
and format as: Custom [h]:mm:ss.00 -- Gary''s Student - gsnu200732 "Terry Pinnell" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert seconds to hh:mm:ss.dd ?
How about using a helper cell with a formula:
=A1/60/60/24 and give that cell a custom format: hh:mm:ss.000 Terry Pinnell wrote: 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 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert seconds to hh:mm:ss.dd ?
Gary''s Student wrote:
=A1/(24*60*60) and format as: Custom [h]:mm:ss.00 Thanks both! -- Terry, West Sussex, UK |
| Reply |
| 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 | |||
Linear Mode
