add a column of hours, minutes

[foxluv]

I have found the answer so many times on the net but for me it has never worked the way it should. For example:

A B
80:00 80:00
80:00 80:00
80:00 80:00
86:00 86:00
0:00 326:00
Column A I used the auto sum function and in column B I used =B1+B2+B3+B4
I formated all the cells as [h]:mm. When you have 50 or so rows to add it is way too awkward to have to used the formula as in column B so how do you get the auto formula of =SUM(A1:A4) to work?

[Mallycat]

it works for me in Excel 2007

[martindwilson]

and me in 97

[DonkeyOte]

what does

=ISNUMBER(A1)

return ?

[foxluv]

I am the originator of the problem and I think I stumbled across the solution? The report I am using with columns of hours is from Pay Clock Pro and this program only allows you to export in Excel 5.0 or HTML or Text. I have been using 5.0 and did not save the report in a newer version before summing the column. I decided to export the report in Text and then save it in my Excel 2002 and that did work. A little more trouble but well worth it to be able to sum the columns properly. Thanks