I have a number of sound files with timestamps (HH:MM:SS), made when walking a transect. I need to know where I was when each file was saved. To do this I have a GPX track of the route I took - I can extract the time for each point along the GPX track however the times don't match exactly with the sound files - the seconds aren't always the same.
These are my sound file time stamps:
Time File 19:32:53 1 19:34:26 2 19:40:43 3 19:40:47 4 19:49:21 5 etc
These are the times of the GPX points:
Time Latitude Longitude 19:30:29 51.4463364054 -2.4129919242 19:37:44 51.4464039635 -2.4128513597 19:37:59 51.4464663249 -2.4127552193 19:38:01 51.4464837592 -2.4127533752 19:55:08 51.4465564303 -2.4127591588 etc
So in the above example I need to estimate where I was at e.g. 19:34:26.
I could achieve this by removing the seconds however I would lose a lot of accuracy and would leave me with redundant coordinates.
Is it possible to do this in GIS? Or might it be best to plot this as a graph? Either way, how would I do this?
I'm on Linux and ideally would like to use Calc/Excel, QGIS or R.