Hello, I have been currently working with Data in which involves time over 24 hours and I am trying to find the sum of these numbers. An example would be the following : 4,889:38:33 + 4,711:28:37 + 4,851:11:26 . Of course, I have removed the comma and changed format, this did correct the issue. However, I was wondering is there a way to find the sum with the comma still involved.
Please Advise
A comma is a formatting character. It should never actually be IN the numeric values entered. Your solution of removing the commas is the correct one.
Last edited by JBeaucaire; 08-12-2014 at 10:20 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
If the data (with the comma) is actually TEXT...
Data Range
=SUMPRODUCT(--SUBSTITUTE(A2:A4,",",""))
Format as [h]:mm:ss
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Tony, I went ahead and tried your method but it did not seem to work. Is there something I am doing incorrectly? I even tried your example on a brand new sheet.
Not sure I understand what you're trying to achieve.
Based on the sample data in post #3, what result do you expect?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks