Setting up an hourly / daily stats spreadsheet

matt_leonard

Board Regular
Joined
Dec 20, 2004
Messages
51
Hi all,

Im having a bit of blank day and have been staring at my screen for quite a while trying to think of some way to do this without it being to messy.

Anyway I need to setup a spreadsheet which does the following.....

I have a list of 5 jobs which are done every hour during the working day and a need a stat for how many was done at each hour. There are 4 people who do these jobs.

I need stats for - totals for each job, each day by each person.
- Overal total for each job each day
- Running totals of all stats during the month

Any ideas of how to lay to this out? We currently have a seperate sheet each day of the month in monthly spreadsheets but they get quite messy and doesn't look to great. I just need something to get me started. What sheets to have and how best to do it...

Any help on this would be great, its hard to explain on forum but thought I would give it a shot...

thank you

Matt
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,215,066
Messages
6,122,948
Members
449,095
Latest member
nmaske

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top