I have a list of time spent per call on the phone. It is in the format
0:00:00:00

Where you have days, hours, minutes, seconds

I have trimmed this to hours, minutes and seconds. However when I use the
Sum() function to add some of them up I get the value 0:00:00, if I use the
=A1:A4 option I get a #Value error, but if I go A1+A2+A3 etc... I get the
right answer.

What am I dong wrong? I have set the call format to time, but it doesnt
help. W want to pull the information into a pivot-table but with the sum()
function not working I am having problems.

Can anybody help please?

Does this help?

http://www.contextures.com/xlfaqDat.html#AddTime

Can you give an example of where the SUM() time differs from adding
specific cell names?


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=563695