How to get time code serial number

  • Thread starter Thread starter Jim Kroger
  • Start date Start date
J

Jim Kroger

Hello, I need to put time stamps in a column formatted as date/time.
Then, I need to get that column into an ascii text file as the serial
numbers, not the date/time. I mean, I need to get the underlying
serial number code into a text file. When I try I just get the
formatted date and/or time.

Thanks for ay help.
Jim
 
excel will automatically convert dates entered, into date format. wit
a date (format) in A1...

=N(A1)

...will yield the serial number for that date (whichever date syste
your using).

alternatively, you could just keep the number, skip the added *formula
step, and format the cell as General to show the serial number.

anyways, lots of options.

HT
 
Jim Kroger wrote...
Hello, I need to put time stamps in a column formatted as date/time.
Then, I need to get that column into an ascii text file as the serial
numbers, not the date/time. I mean, I need to get the underlying
serial number code into a text file. When I try I just get the
formatted date and/or time.
Click to expand...

Hi Jim,

=Value(A1) where A1 is the date.

That will yield the serial number.

Hope that helps.

Best regards,
Kevin
 
Back
Top