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.