I am trying to add the total amount of time required to perform certain activities by person.
I have 12 activities per person and there are 8 persons, each of the cells, including the totals per person are formatted (Custom, hh:mm). I then add all of these cells to create a total time for all activities per person. In two cases the total hours show as 03:01 and 1:37. However, by looking at the number of hours per activity I calculated that there totals are actually 27h01m and 25h37m.
So, how do I get the total cells to display 27:01 and 25:37?
Any ideas would be very welcome!! Many thanks.. .