I am trying to get a sum of time spent on the phone for agents. The format the duration is in is hh:mm:ss when I format the column and do =C2+C3 I get the correct output. When I do =SUM(C2:C55) the sum is 00:00:00. I've tried a few different ways to format and calculate the sum without luck.
Example in (hh:mm:ss)
C1= Charles talk time each day
C2 = 02:45:11
C3 = 03:44:47
=C2+C3 output is 06:29:58
=SUM(C2:C3) output is 00:00:00
Example in (hh:mm:ss)
C1= Charles talk time each day
C2 = 02:45:11
C3 = 03:44:47
=C2+C3 output is 06:29:58
=SUM(C2:C3) output is 00:00:00