How to add time duration column total from Skype Call History CSV file in Excel 2010?

This will be a little convoluted but I think it should work. Note, I am using Excel 2007 for this, so some steps may be a little different.

After importing your file (post step 9 above) perform the following:

1. Insert two columns between Duration and Amount
2. Select the data of the Duration column and go to Data > Text to Columns
3. Choose Delimited (OK) and check Other under Delimiters, entering a colon ":" in the box. Then press Finish.
4. The first of the two new columns should have numbers in it now.
5. Change the Format of the second new column to General.
6. In the second new column, in the first row under the header row, enter the formula =TIME(0,F2,G2) (where column F is the Duration column, column G is the first new column and row 2 is the first row beneath the headers)
7. Fill the formula down for each row of data.
8. Change the Format to display the data as desired (ex. as hh:mm:ss)
9. Copy and paste Values and Number Formats from the second new column into the Duration column.
10. Delete the two new columns.

This should produce output similar to thus: