When I calculate the sum of times i am getting 0 (Zero)
I am calculating the sum of times and i am getting 0 as the result. Please help me.
I have changed the time format in format cell also. But still I am getting 0(Zero)
Please help me.
I am attaching the file also.
That is a text values looks like H;mm:ss format. Select the column go to,
Data | Text to columns | Finish.
Also, you have circular Reference in A31, change formula to =SUM(A1:A30)
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
The problem is the data, you have actually entered 00: as the first three digits, so you have entered a text string, not a time string. You can't sum text string with the SUM() function.
So, I removed the leading 0 and the values converted to time. I changed the "format" to [hh]:mm:ss so that is still displays the leading zeros. Now the SUM() will work.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks