Jun 01 2023 10:35 AM
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?
Jun 01 2023 12:01 PM
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.