| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change an integer into hh:mm:ss
Hi,
I have a bunch of number -- integers -- that represent time in seconds. I need to do some calculations then display results in hh:mm:ss format. How do I convert integers (seconds) into time values? For example I have 3600 as a value in cell A1. This is 3600 seconds. The time value of this would be 1:00:00. I'd appreciate help on this. Thanks. Sam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
| integer | Excel Worksheet Functions | |||
| Excel ActiveX Scrollbar - change from integer to decimal | Excel Discussion (Misc queries) | |||
| integer value won't change | Excel Programming | |||
| Not seeing integer | Excel Programming | |||
Threaded Mode
