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.
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)
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
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)
Bookmarks