Sounds like the cells are text, not proper time

Instead of Sum, try this

=SUMPRODUCT(--(A1:A10))

and format as [hh]:mm:ss

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bugjam1999" wrote
in message ...

thanks for the reply... but that doesn't work. Sum just produces the
result 00:00. Thats what got us stumped, all of us have used the sum
function loads of times before without difficulty... but it doesn't
work this time :(

next suggestion please?

thanks...


--
Bugjam1999
------------------------------------------------------------------------
Bugjam1999's Profile:
http://www.excelforum.com/member.php...o&userid=26178
View this thread: http://www.excelforum.com/showthread...hreadid=394908