Re: Batch modification of source clips.

After you're done in Excel, you recreate the media end field with text concatenation using & sign in a formula:

=hoursCelladdress&":"&minutesCelladdress&":"&secondCelladdress&";"&framesCelladdress

Copy and paste the new column as "values", get rid of the columns you used for working formulas, and save as tab delimited text file.

Import batch list into FCP.

Good note, that you also need to change the duration field properly.

All goes to show that there's more than one way to skin a cat, which is the motto of post production (except cat lovers hate that saying).