+ Reply to Thread
Results 1 to 3 of 3

need help creating a timesheet to track one employee over different jobs

  1. #1
    Registered User
    Join Date
    10-22-2010
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    need help creating a timesheet to track one employee over different jobs

    I am working on a "time sheet" the way it is configured now is there is a sheet called jobs. this sheet has 3 columns (job #, Cust, Job). Then I have a sheet for each week of the year. these sheets have columns (date, job#, cust, job, operation, start time, end time, total time, and paid).
    What I am trying to figure out is how to create a formula in the jobs sheet to total hours spent on each job over the life of the job. There will be a new sheet added each week.

    Thanks for the help.

    I have attached a sample of the file for evaluation. I am using 2003 or 2007 which ever would work better.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,449

    Re: need help creating a timesheet to track one employee over different jobs

    Hi pbneal,

    I'd suggest not having your weekly jobs all on separate sheets. I've copy and pasted them all to the same sheet and then done what I think you want. If they are all in a single table they are much easier to work with. See the attached.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: need help creating a timesheet to track one employee over different jobs

    thread moved from Tips & Tutorials to Excel General - the former is not intended to act as a Q & A forum.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1