troubleshooting Question

question about Excel time format

Avatar of Mike Day
Mike DayFlag for United States of America asked on
Microsoft Excel
3 Comments1 Solution333 ViewsLast Modified:
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.
Rob Henson
Finance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros