| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format conversion
You are welcome! Thanks for the feedback!
Stefi mftr ezt *rta: Thank you EricBB, Mike H and Stefi for your quick responses; each of your suggestions made it work like a charm. mftr "Mike H" wrote: Hi, divide by 86400 (Seconds in a day) and format as mm:ss Mike "mftr" wrote: How can I convert a three digit seconds figure to minutes and seconds in a mm:ss format (i.e. 162 seconds as 2:42)? I can get the right raw number by dividing by 1440, but that seems to produce an h:mm format, albeit with the right digits. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Format Conversion | Excel Worksheet Functions | |||
| time conversion | Excel Discussion (Misc queries) | |||
| Time conversion | Excel Worksheet Functions | |||
| Time conversion | Excel Discussion (Misc queries) | |||
| time conversion | Excel Discussion (Misc queries) | |||
Hybrid Mode
