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

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
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)
 
Back
Top