Pivot Chart Reporting 0's on time totals

Your sample file does not include an actual pivot table, so it is difficult to know what you are doing wrong.

If I create a pivot table based on the data, I have no trouble with the pivot table summing the times correctly.

If I had to guess what was going wrong, two possibilities come quickly to mind:

1) All of the times in the data are integer day values, so any sum of those values is also going to be integer days. If you choose a "time of day/24 hour clock" format, they will all display as 00:00:00, representing midnight on the morning of whatever number of days are summed. Make sure you are using an elapsed hours format, like you are doing in the source data.

2) All of the times in your actual data set are text and not numbers. Even pivot tables will ignore text (including numbers stored as text) when summing. If all of the times are really text, then the sums will be exactly 0 days. Of course, your sample data is not showing this scenario, so you would have to look at your real data to determine (=ISTEXT() can be useful for seeing if you have a number stored as text).

If neither of those leads to a solution, I suggest putting together a new sample file that better represents the data you have and the problem you are experiencing.

See if this helps

When I open your file in post #4, without any edits, all of the sums in the pivot table look correct. 48 hours (2 days) for Jacob on 3/2/2023, for example. Your comment on the side of the pivot table says you are getting 0 days/hours in the pivot table, but I am not seeing that.

Did you test the 2nd possible reason I gave in post #2 -- that the times are actually stored as text rather than numbers?

I didn't change anything, as such.

I inserted a Pivot Table on the same page so I could see what was happening. I used the Format Painter to copy the raw data format to the Pivot Table. Then I converted the raw data to a Table so I could check the filtering. Nothing untoward.

Oh, I told it to sum the values rather than count them (which I think is the default).

When I open your file in post #4, without any edits, all of the sums in the pivot table look correct. 48 hours (2 days) for Jacob on 3/2/2023, for example. Your comment on the side of the pivot table says you are getting 0 days/hours in the pivot table, but I am not seeing that.

Ditto for me too.

Suspect it is related to the source of the data - the report.

Ideally, post a redacted copy of the original report

Glad you have a solution.