View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bourbon84 bourbon84 is offline
external usenet poster
 
Posts: 7
Default converting number to time

I have a column of numbers, ranging from 0 to 4000 seconds; A1 is 0, A2 is 1,
A3 is 2, etc. How do I convert that column to represent time, where 0 seconds
is 00:00:00, 1 second is 00:00:01, 2 seconds is 00:00:02, and 60 seconds is
00:01:00, etc.? Thanks.