How I matched dashcam video timestamps to rideshare trip records

I ran into this in a rideshare support review where a driver submitted dashcam footage for a disputed trip. The issue was the video timestamp did not line up with the trip timeline in the driver app. At first I blamed the driver sending the wrong file, but it showed up whenever the dashcam had not adjusted for daylight saving time. This caused support could not confidently match the clip to the…