Changing time offset in Excel column

Friends, as my last resort, I came to this forum, to ask experts on how to solve a problem. Namely:
I have an excel file with three columns. Column A is timecode. Columns B and C are texts. There are over 700 rows in this file (I have to do this for approximately 30 different files). What I would like to do is to change time offset in the first column by adding 2 minutes 35 seconds to all rows in column A. For example:

01:12:10:21 IZZY (voiceover) Pixie Dust Away!

01:12:15:03 IZZY Jake! Cubby! Wake up!

01:12:18:04 JAKE What's going on, Izzy?

would have to be:

01:14:45:21 IZZY (voiceover) Pixie Dust Away!

01:14:50:03 IZZY Jake! Cubby! Wake up!

01:14:35:04 JAKE What's going on, Izzy?

etc.

The first problem is that the time format 01:12:10:21 means hours:minutes:seconds:frames, however, frames are not important and can be omitted, only time units are important. I really have no idea how to approach this problem. I would truly appreciate your help.
Kind regards and thank you very much. I'm attaching the file if anyone is willing to help... Thank you kindly.

jake1.xls

I wrote a little script that should do it for you, and will preserve the frames.

To use VBA code go to Excel, hit Alt+F11, Click Insert->Module, and paste the code there, and close that window.

To call the code, hit Alt+F8 and choose to run ChangeTime.

Please Login or Register  to view this content.

I'll give you the play by play with comments inserted in the code, so you can preserve them for later use.

The code will ignore each line that begins with ' so you can leave it in.

Check the code in the workbook attached.

Glad I could help out.