Sum Date

Highlighted
Occasional Visitor

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 think it has to show me  18897:00

And if a write 9008:00 + 12:00 it can show the correct result "9020"

Please Help me!

2 Replies
Highlighted

Hi,

 

Sounds like one cell is formatted as a time format giving 12.25 while the other cell is formatted as a decimal?

Highlighted

If all cells are in elapsed time format ([hh]:mm), Excel shows result as expected

image.png

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