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 the previous total (19245:40) even if the format of all the cells is [h]:mm.

Any idea about how I can fix the problem? Tks

​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 the previous total (19245:40) even if the format of all the cells is [h]:mm.Any idea about how I can fix the problem? Tks  Read More

​