View Single Post
  #3   Report Post  
Tim C
 
Posts: n/a
Default

Do you have an example number and the approximate date/time that it should
represent?

Tim C

"Margo" wrote in message
...
I have some system logs that have a number that is either a serial number
or
the number of seconds. I have tried to use the Convert function, format
the
cell to date/time, but it doesn't look reasonable. I've read that serial
numbers start at 1/1/1900, but this would put my date/time at september
2005,
and we aren't there yet. :) Any suggestions and ideas would be helpful.