Average per day in a week

[korygrandy]

Ultimately what I want is a chart that shows an average open ticket time for a particular week shown in days Monday-Friday. I'm assuming I will need an average per day and then somehow put that into a Graph by week. I included the worksheet with the raw data. I just don't know where I would start to get this going.

[arthurbr]

For your daily average should the ticket's opening day be considered or it's closing day?

[korygrandy]

Arthur I should have clarified. The average is based on the closing day ticket. Thank you for your help