Author Topic: Adding timestamp from "4/21/2020 20:06" Format?  (Read 149 times)

newoski

  • Newbie
  • *
  • Posts: 6
Adding timestamp from "4/21/2020 20:06" Format?
« on: May 24, 2020, 05:24:58 PM »
Hi,

I have an excel file with create times for all my photos in the format below:

4/21/2020 20:06

What command line could I use to replace the existing create/modified date with above?

Thanks!!

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 3693
Re: Adding timestamp from "4/21/2020 20:06" Format?
« Reply #1 on: May 24, 2020, 05:47:59 PM »
How do you plan on doing the update?  Saving to a CSV file?  In that case I would suggest just reformatting the cell to some form of YYYY MM DD HH mm ss (see FAQ #5), saving to the csv, and then undoing the change if you like.  You will need to add a seconds value of some sort.

Otherwise, some more info would be need as to how you're getting from excel to the actual files.  But the object would be to get the format into some form of YYYY MM DD HH mm ss.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

newoski

  • Newbie
  • *
  • Posts: 6
Re: Adding timestamp from "4/21/2020 20:06" Format?
« Reply #2 on: May 24, 2020, 07:14:11 PM »
How do you plan on doing the update?  Saving to a CSV file?  In that case I would suggest just reformatting the cell to some form of YYYY MM DD HH mm ss (see FAQ #5), saving to the csv, and then undoing the change if you like.  You will need to add a seconds value of some sort.

Otherwise, some more info would be need as to how you're getting from excel to the actual files.  But the object would be to get the format into some form of YYYY MM DD HH mm ss.

I plan to use the data as part of CSV batch replace

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 3693
Re: Adding timestamp from "4/21/2020 20:06" Format?
« Reply #3 on: May 24, 2020, 07:52:08 PM »
Then my first suggestion would be the best.  Use excel to change the format.  In Libreoffice, I would just right click the column, select format, then look for the appropriate date/time on the list and apply.  I don't have access to excel so I can't advise the best way there.

Save the file as a CSV.  Then you can click undo to return it to its original state if you like.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

newoski

  • Newbie
  • *
  • Posts: 6
Re: Adding timestamp from "4/21/2020 20:06" Format?
« Reply #4 on: May 24, 2020, 08:10:45 PM »
Then my first suggestion would be the best.  Use excel to change the format.  In Libreoffice, I would just right click the column, select format, then look for the appropriate date/time on the list and apply.  I don't have access to excel so I can't advise the best way there.

Save the file as a CSV.  Then you can click undo to return it to its original state if you like.

Thanks so much!