I have three columns in an Excel Worksheet.

Table Name
Time of Data Transfer
Size Data Transfer

Would anyone know how to format the Time of Data Transfer and Size of Data
Transfer column so that I could use the SUM function to get a total.
Here are the two columns:

4s 6 mb
1h28m52s 71.66 mb
1h20m57s 1110.83 mb
2h28m9s 699.39 mb
48s .19 mb
92s 3.61 mb
10s 18.53 mb
1h4m15s 584.68 mb
36s .36 mb
1.1s 4.21 mb
1.4s 13.27 mb
21s 21 mb
15s 3.07 mb
1s .20 mb
5m 111.45 mb
1s .02 mb
0

Thank you.