I have a two-column array, where column 1 is a list of names and column 2 is times. How can I sum the times in column 2 with the same name in column 1?
This is an example of the data and I want to sum the times in column 2 that correspond to the name in column 1. eg. the total time grazing would be 01:15, the total time resting would be 03:13.
resting 03:06
walking 00:32
grazing 00:12
resting 00:07
grazing 01:03
I'm sure there must be a formula which would allow me to calculate this rather than doing it manually which will take a long time as there are a lot of data.
Thanks for your help.
Bookmarks