Hi, I have a large number of worksheets that all individually work
with time, doing different things. I then link these to a master
sheet, which has 17 columns, each colum has many workbook time totals
averaged out. The strange thing is that 15 of the 17 colums work
flawlessly and 2 don't. There is no difference in the way the 2 non-
working colums are formatted, linked, data originally input, or
anything else. They are for all intents and purposes identical except
of course for the actual values i.e. the times are different.

The 2 non-working colums, give me the standard error message which
indicates that the number is very large or negative, the actual time
(when I total them up by hand on a calculator) is no larger or smaller
than any of the other numbers.

I've spent 5 full days working back through thousands of columns of
data to see if somehow some gremlin got in, and there was an incorect
format, but everything is in the correct excel time format h:mm:ss

So, where can I look, I'm sick of seeing these ############ instead of
a time. Naturally any help will establish the helper as a living
legend and I'll make an urban myth out of you :-)

Thanks in advance.
Ron