Tech Support Guy banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
159 Posts
Discussion Starter · #1 ·
I have a sheet that contains a list of numbers for each hour of each day, monday through sunday 1 to 24. I need a formula to calculate the average of those numbers for the full week and then I need to make a chart with those averages. Can anybody help?
 

·
Registered
Joined
·
2,311 Posts
The file (HrPerDay.xls in the zip file) attached here is my attempt to what you might want.

I made a column for hours in a day (1 am to 12 am, midnight) and separate columns for the days of the week with a final column for averages.

Then I just used the Excel chart button to create the line chart. It is pretty simple.
 

Attachments

1 - 3 of 3 Posts
Status
Not open for further replies.
Top