Hi All,

First off I am self taught on everything I have done in Excel thus far with the help of YouTube and various google searches (am having a lot of fun learning new tricks) so I apologise if this is a simple fix but I haven't found a solution yet

I have an excel sheet for work where I show what errors I have corrected across multiple jobs and how long each task takes, one job may have 3 errors that took 5 min to fix, another may have 1 error that took 5 on it own or another that has 9 errors that 10 min to correct
What I need is something to show the average time it took for the total number of error

For example in January I corrected 251 errors, the total time this took was 6 hours 28 min......what would the formula be to show how long it took for each issue?


thank you in advance