Adding time

[Keith]

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 doesn’t
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?

[Special-K]

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?