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
MVP
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