View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FD FD is offline
external usenet poster
 
Posts: 2
Default autofill timestamp

I have a table with over 4000 records collected with a gps every second, but
the timestamp it gives does not make sense (eg.78419863). I am looking for
some help to calculate the values of a field so that it takes the first
record of the field and adds 1 second to each record after the first time. Is
it possible to have the timestamp read hh:mm:ss