Forum Discussion
adding large numbers of hours in escel
hi, i am trying to add a large amount of hours (19:245:40) in an excel file to get the total flight time of a pilot in his lifetime. The problem is the function SUM does not include the big number of...
We may enter in the cell the maximum time not more than 10000 hours. If try to enter bigger time it appears as text. SUM ignores texts.
Maximum times in Microsoft Excel - Microsoft Support
However, we may calculate time more than 10000 hours. If enter 9999:00 and 9999:00 and sum, it gives correct result.
