I have a 1 column list of rows that I pasted into excel that look like:

1:15 0:25 0:43

These represent hours and minutes worked each day, I want to sum up the total and see how many hours I have worked. I can't seem to figure out how to do this in Excel, I know I use the formula:

= FIRSTCOLUMN + LASTCOLUMN

but the issue is excel is not handling the format of the column (I think)