I've got a battery operated remote video camera that saves its files to a memory card, I hadn't appreciated that the date/time settings on the camera had defaulted back to the factory settings so are years out of date. Hence all the date-time stamps on the video clip files are wrong.
I've taken two date/time readings - one from the camera and one from my watch. I reckon if the difference can be worked out (I'll call it 'Time Error') and that is then added to each of the time stamps of the video clips I should end up with the correct time.
Below is as far as I've got. I can't seem to find a formula (that works) to get the Time Error and, from that, to add it to each clip time to get the corrected clip time.
Would be grateful for any help before my brain fries
I've taken two date/time readings - one from the camera and one from my watch. I reckon if the difference can be worked out (I'll call it 'Time Error') and that is then added to each of the time stamps of the video clips I should end up with the correct time.
Below is as far as I've got. I can't seem to find a formula (that works) to get the Time Error and, from that, to add it to each clip time to get the corrected clip time.
Would be grateful for any help before my brain fries
| Videocam Clock Time | Actual Time | Time Error | |
| 28/12/2017 03:24 | 11/08/2023 17:18 | ||
| Video Clip Number | Video Clip Time | Corrected Clip Time | |
| 10 | 23/12/2017 00:51 | ||
| 12 | 23/12/2017 10:03 | ||
| 15 | 23/12/2017 18:16 |
