Totaling on hours problem
I am sure this is simple for the folks who know what they are doing. But I'm stumped.
Attached is a simple spreadsheet that has columns of start/end times, and a column for the duration represented by the start/end times. I want to total the hours at the bottom of the table for the duration. But I'm not getting a correct total.
I also have a pivot table in it that I'm trying to list each category (tag) and total hours for each category. Of course, I'm not getting correct totals for that.
I'm thinking I need to format something different. Wondering if anyone here has any suggestions.
Spreadsheet attached.
|