SOLVED

Summary difference in table

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3166925%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ESummary%20difference%20in%20table%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3166925%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348300iB612ECF13E1F6CAE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Robert_75_1-1644922074752.png%22%20alt%3D%22%5C%26quot%3BRobert_75_1-1644922074752.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ekollumn%20%22H%22%20is%20set%20to%20present%20%22time%22%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWhy%20do%20i%20get%20a%20differense%20in%20cell%20H68%20in%20my%20table%20from%20the%20summary%20in%20the%20bottom%20right%20corner%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3166925%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

Robert_75_1-1644922074752.png

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

@Robert_75 

 

Try removing the filter in column B.

best response confirmed by Sergei Baklan (MVP)
Solution

@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.