View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 3
Default 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