you already recevied an answer on how to do it. However,

With your current formulas you could do

=TEXT(SUMPRODUCT(1*H2:H9),"[hh]:mm:ss")

--
Regards,
Tom Ogilvy

"Tamara" wrote in message
...
If this function works: =TEXT(F9-E9, "hh:mm:ss"), why doesn't this:
=TEXT(H2:H9, "hh:mm:ss")? I have a form enter start and end times. In
another column I use the first function above to calculate the elapsed
time. I would like to total that column in hh:mm:ss format. How do I
do this?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!