How do I change an integer into hh:mm:ss

[Sam]

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

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>