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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change an integer into hh:mm:ss
put
=24*60*60 (or just enter 86400 in the cell) in a cell to calculate the number of seconds. Then copy the cell and select your integers. Do Edit=Paste =special and select Divide format the "integers" as Time. Time is stored as a fraction of a 24 hour day. This should convert to a time value (1/24th of a day) -- Regards, Tom Ogilvy "Sam" wrote in message ... 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 |
Reply |
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 |