I have cells formatted as time using the Custom setting - "[hh]:mm:ss". I can individually add multiple cells i.e. A1+A2+A3 and have the correct answer returned. However, when I use the AUTO SUM function it returns 00:00:00. This result is true whether or not the sum result is more or less than 24 hours. HELP!
Thanks,
Bookmarks