Thread: Time Format.
View Single Post
  #3  
Old June 2nd, 2010, 09:16 PM posted to microsoft.public.excel.misc
David Biddulph
external usenet poster
 
Posts: 8,714
Default Time Format.

=A1/(24*60*60) and format as [h]:mm:ss
--
David Biddulph


"GEM" wrote in message
...
I have a column with numbers that represent seconds, for example 109.

How can I change this number (109) to this format, 0:01:49