How to make excel calculate 9 hours as one workday

[John Smucker]

I would like to find the average days and employee worked in a week month and year. 9 hours = 1 Day
How do I make Excel Calculate this.
Attached is an example of my Worksheet..

 

[mikerickson]

What is the desired result from your data

 

[John Smucker]

I apologize I wrote it wrong in the last post. The "Average days this week" cell should be changed to "Total days this week"


All I need is for Excel to Sum up the Values in the "Total Hours" column making nine hours = 1.00 day 4.50 hours = .50 days etc...

 

[mikerickson]

What are the desired results of your sample data?

 

[John Smucker]

According to the value's in the first week, in the January timesheet that I have attached, the employee would have worked a total of (five point something) days.
And he would've worked and average of 5 days per week in January (in the "Average Days This Month" cell).
All I need is a formula to calaulate 9.00 hrs as one day and that sums up the Total Hrs. column resulting in days..

 

[mikerickson]

If you are accepting frational days, then something like =SUM(E6:E13)/9

 

[John Smucker]

If you are accepting frational days, then something like =SUM(E6:E13)/9

Works Thank you!..

 

[John Smucker]

Works Thank you!..

.

 

[John Smucker]

If you are accepting frational days, then something like =SUM(E6:E13)/9

 

[John Smucker]

Now if you take a look at the dates in that sheet, can you tell me what for formula to use in conditional formatting to not show the dates from the previous and the next month.
Thank You..