I have a spreadsheet that has the been exported from a data base into excel.

the cells have times in them as -

03:24:00 03:28:00 03:31:00 00:00:00 03:41:00 03:52:00 04:04:00
04:19:00


When I go to cell property it shows it as "general"

I have close to 3000 lines as above.

I need a way to calculate 03:24:00 and 04:19:00 to total 00:55 in another
cell

1) How can I convert the cells to hr mm and not delete the data

2) How do I calculate the SUM of minutes to get a total amount of minutes
for all the times?

Any help is greatly appreciated!!

Steve