Work Hours Doscument

[StevenYoungGSB]

Hi all,

First time poster and feeling a little out of my depth on this one.

I've created a lot of "programs" in the past using excel to generate kit weights for buildings, generating memberships etc, but I'm at a total loss here and need help.


Essentially, what I am trying to achieve is to create a work hours template.

The user will at the beginning of the month select the first worksheet and add any jobs they have been doing, and then a time in hours against the job from Monday to Friday.

So for an example, "Allan" might be doing work on a Site called Kinross. He then marks 3 hours against it on Monday and 2 hours against it on Tuesday.

The following week, Allan goes back to working on Kinross and clocks up another 5 hours.

What I need to happen, is for a 5th page to report all the hours against each distinct job to generate a monthly report. In addition, each type of job is in it's own category. So example: I could be doing work on the site at Kinross under Sites, but also doing work on the Kit Production for Kinross as well.

Would anyone be able to help me?

[southward]

Hi,

While individual sheets for each week and/or for each employee look good from the start, they can prove to be cumbersome and unwieldy over time. Not to mention very difficult to compile data.

My suggestion involves a data structure change.

Create one data entry sheet where all the applicable information goes in a very structured format.
All applicable data is entered for every event on a new line as it happens.

In this situation: Date, Job Description, Location, Name, Hours

You can standardize the data entered via pull downs that pull exact information from a Data Sheet. Doing this prevent typographical errors.

Then you can create report sheets to pull the desired info from your Data Entry sheet.

Attached is a modified version of your data containing 3 new sheets: Data Entry, New Time Sheet and Data Sheet.

The New Time Sheet contains a Pivot Table with a Slicers.

Take it for a spin around the block.

If this is a structure you like, I would be happy to help if you have any questions.

Hope this makes sense and is helpful.

Cheers