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
Bookmarks