Pivot Chart

Copper Contributor

I'm working with summing up time on a pivot chart but the problem I'm running into is the chart says 22 hours is smaller than 14 hours...so on a bar graph, the bar for 22 hours is shorter than the bar for 14 hours. Why is this backwards?

1 Reply


Perhaps the 14 hours is actually 24+14 = 38 hours?

Apply the custom number format [h]:mm to the time values and see what it looks like.

[h] is cumulative (elapsed) time, while h is clock time.