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

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