Forum Discussion
Enrique1785
May 26, 2024Copper Contributor
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...
SergeiBaklan
May 26, 2024MVP
In addition, since formulae work with such time, you may enter
=19245/24+40/24/60
instead of 19245:40. Above formula will return correct time instead of text value.
Enrique1785
May 26, 2024Copper Contributor
SergeiBaklan Tks a lot for your help.
- SergeiBaklanMay 26, 2024MVP
Enrique1785 , you are welcome