can you elaborate a bit about the problem? I don't seem to have trouble using the Sum function to add times, using Excel 97. Is it comething to do with your formats?
> from: "Rushton, Martin [LIS]" <[log in to unmask]>
> date: Fri, 08 Nov 2002 11:23:59
> to: [log in to unmask]
> subject: Re: Sometimes?
> Poetic license and not a VBA but an Excel question.
> I'm running Excel 97 and would like to Sum a range of times which may be expanded in the future. If I use autosum it returns 0:00:00 but if I manually sum the cells e.g. a1 a2 a3 ... the result is correct. Help is no use at all and the MSKB is very frustrating in that, in its articles on how to display more than 24 hours it mentions using the autosum in the XL95, 2000 and 2002 articles but nothing about 97.
> Is 97 the odd one out is it not possible to use the sum function or another function I'm completely overlooking on a range of times?