| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coverting seconds into hr:min:sec
Or, if you absolutely have to have the "hr", "min", "sec" text in the
results, you could use this formula....it is a bit long but works. =INT(A1/3600)&"hr "&INT(((A1/3600)-INT(A1/3600))*60)&"min "&ROUND(((((A1/3600)-INT(A1/3600))*60)-INT((((A1/3600)-INT(A1/3600))*60)))*60,2)&"sec" Where A1 holds the number you wish to convert "jsturino" wrote: I woul like to find out how to convert seconds into hr:min:sec. For an example I would like to take 3661 seconds and convert it into 1hr 1 min 1 sec. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
| How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Threaded Mode
