Forum Discussion
Sum Date
Hi there. I have a problem with my excel. I am trying to sum hours. For example: I want to sum 18885:00 (hours) + 12:00 (hour and minutes) but it only show me 12:25. How can it be? if I ...
If all cells are in elapsed time format ([hh]:mm), Excel shows result as expected
Another story is how you enter first hours - if that's result of some other calculations or entered as full date it shall be no problem. If you enter manually the maximum time value you can enter is 9999:99:99 https://support.microsoft.com/en-ca/help/214386/maximum-times-in-microsoft-excel