Hello
Im trying to add call time that I pull for my sales team. The format it comes out in excel is HH:MM:SS if they had a total talk time of more then an hour. If they only taked for says 45 minutes it comes in like this :45:00.
The problem I am having is that I can sum everything that is formated comes in as 00:00:00 but not if its :00:00. I put an example below. It sums the first two but not the second to. So far the only fix I have is manually putting an a 0 in front. Which really is time consuming for the volume I work with. Any suggestions on how to get it to sum or convert to a 00:00:00 format.
Rep 1 1:00:00
Rep 2 1:23:51
Rep 3 :07:51
Rep 4 :40:20
Sum 2:23:51
Bookmarks