Now that all fields are aligned, we need to adjust the formatting of the timestamps:

CTRL + Left Click columns B, E and F
Go to Home, Number and Open the Number format dropdown.
Select More Number Formats, and select Custom.
In the textbox Type: Enter the following text:

yy:mm:dd hh:mm:ss

Press OK.

The formats of all fields should have changed to the corresponding datetime format.

To determine the offsets, we need to find difference between the ImageTimestamp from the TriggerEventTimestamp.

If the images were at the top of the table (only A and B filled):
Select cell F2 and enter the following formula

=E2-B2

If the image timestamps are ahead of the PPK (A and B empty at the top):

Select cell F2 and enter the following formula

=-(B2-E2)

This will now show the date time offset for the first picture. Double click bottom right corner of the F2 cell to copy the formula to the cells below.

The offsets of the Images and Trigger events should be roughly equal, a second or so of variation is expected.

This timestamp is what is going to be used to correct the images.

Geotagging troubleshoot: Image timestamp adjustment for Sony cameras

Problem Identification