Summary difference in table

New Contributor


kollumn "H" is set to present "time"

Why do i get a differense in cell H68 in my table from the summary in the bottom right corner?

3 Replies



Try removing the filter in column B.

best response confirmed by Sergei Baklan (MVP)

@Robert_75 Custom format H68 as [TT]:MM:SS (noticing you are using Swedish Excel) . Then you will get the same total as the one at the bottom. The square brackets change the hours portion from Time to Duration.

Thank you Riny_van_Eekelen. This solved my problem.