I've got 2k rows of time (from a Toshiba fax log) in two different formats
- 1:10 = 1min 10sec
- 27:55:00 = 27min 55sec 0ms
I want to total/sum this time column however it calculates wrong (5:05 instead of the actual 29:05) maybe because it thinks the second time format is hours? I can't seem to format or convert these in a second column with a formula so I can get a grand total.