I have a spread sheet that among other things gives me a total of equipment running hours ie. H30 =sum(H36+K36) H36 is the previous total now approx 12531:30 hrs, the running hours daily, up to 24 hrs (K36) are added to this total, the relevant locations are formatted Custom [hh:mm] a new page is created each day using a macro.
recently when the page was updated I had a #data error in the total cell (H30) this is now persistent and I can't seem to get rid of it.
I think it might be because of the high number count of hrs, if I reduce the total hours in the cell the error goes away.
Is there a maximum number that the cells can handle ??