SOLVED

Summary difference in table

Copper 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 VI_Migration (Silver Contributor)
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.
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
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.

View solution in original post