Pivot table and calculation issues

[mikenz1983]

Hi Team

I wonder if you can help
I have a Sheet that contains raw data of all emails received into a mailbox over x amount of years, the task i have is i am calculating the amount of time it takes to manage these emails daily to then ascertain staffing needs, for this case we are saying every email on average takes 9 minutes

Anyway, to do this i have placed a column next to each email with the number 00:09:00 ( formatted as hh:mm:ss ), i have then done a pivot off this into another sheet

Sample of raw data ( ive ommitted some sensitive data ), however if i work of the date being the 02/12/22 ( or in this case american format of 12/02/22 ) i get a total count of 964 emails

My Pivot however looks like the below, the "sum of time to complete" is a sum of all values in column F formatted to hh:mm:ss, this seems to be really underbaking the figures as 964*9 minutes per item is far more then 2 hours

Row Labels	Sum of Time to complete
2022	12:09:00
1-Dec	10:30:00
2-Dec	02:15:00
3-Dec	13:39:00
4-Dec	19:57:00
5-Dec	05:33:00
6-Dec	23:15:00

When i double click on the pivot value to look at the raw data it is pulling it is in fact pulling the correct information and the count is 964
i am thinking i have something wrong with my formatting somewhere

Any ideas on what i could be doing different here please

Thanks

 

[RoryA]

If you want to show more than 24 hours, then you need to use [hh]:mm:ss as the format.