GATORWOMAN48
New member
- Joined
- Jan 21, 2020
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
I am in a metrics based position where the tickets I work are timed for how long I am in there and it is in HH:MM:SS format. So if I was in a ticket for 1 hr 15 mins 2 seconds obviously the report would read 01:15:02 as an example. I want to take the column and add up that "time spent in ticket" however when I use the sum formula it will not work. I am trying to verify that the reports for each category I do are correct as I believe that they are not. Any help is appreciated.