I'm trying to figure out an easy or efficient way to convert the timestamps contained in GPX files to a different timestamp. I have data for air quality levels saved in an excel spreadsheet and want to match up timestamps between my air quality data and my GPX file so that I can join tables in ArcMap and overlay air quality levels over the GPX track.
To give you an idea of what I mean, this is what the timestamp looks like in the GPX file:
And this is what the timestamp looks like as saved in the excel sheet for my air quality data:
If I could figure out a way to convert one timestamp to another without going through each row and changing them manually then I could use these timestamps to combine the tables from my GPX file and the excel sheet so that I can overlay my air quality data onto a map.
Is there a tool online, in ArcMap, or an easy way in excel to mass convert timestamps so that the two timestamps I posted above are in the same format?