asked on
I have a .csv file I extracted from our phone system to add up number of minutes each receptionist is on the phone. the amount of time on the call comes over as 00:03:21(looks to be as general text), which is 3 minutes, 21 seconds on that call. i have over 3400 entries for just one receptionist. what i can't figure out is how to get a total sum of this column, like 12:45:47 (12 hours, 45 minutes and 47 seconds in phone calls total for this month for this receptionist). i have tried all kinds of format changes. if i type in 00:03:21, it displays 0:03:21 in the column and then the sum works. and the cell is displayed as an actual time, 12:03:21 AM. not really what i want but it does appear to add correctly. even thought i could add a column and custom format it but it just copies the same thing. it has to be the format of this column but i have searched high and low for a solution. hopefully i have described my issue with enough detail. i am using excel 2010.
thanks
thanks
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.