Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: calculate time and job hours

  1. #1
    Guest

    Default

    in my job, (about 20 workers) write how many hours they've worked, and where they worked (we have several different job sites, and this could change oftenly.)

    now, we bill per job, and part of calculating this job is calculating job hours. at the same time, this form that the workers use is also used to calculate pay hour.

    currently everything tis done by hand... sooo... being bored, i decided to automate this function so that all one would have to do is enter what is written on the paper.

    also, i'd like to be able to enter new employees and new jobs from that same area.

    i was thinking of using combo boxes in vb, but some how i can't get the "linked cells" property to show up.

    soo... i need to create 2 different reports (one for job hours, and the other for pay hours) and at the same time change/update information in the workbook.

    any ideas?

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put all the data you possibly can in a workbook.

    For instance, sheet 1 should have all your workers going down column A. Sheet 2 should have job number in column A and job name in col b.

    Then tell me how much you want to track--a week or a month at a time.

    Email it to Dreamboat@TheWordExpert.com
    ~Anne Troy

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I created a sample worksheet where you can just put your own info. Email me.
    ~Anne Troy

  4. #4
    Guest

    Default

    i was thinking of tracking this information bi weekly (as payroll) but the hours to be tracked for job hours is over a long period of time (some jobs last a year).

    thanks for any help!

  5. #5
    Guest

    Default

    you also understand that workers would enter in their time as:

    name: john doe
    date: 3/07

    time in time out job
    8:00 12:00 bilbrey
    12:30 18:00 jones

    then you create a report
    which would be for payroll:

    john doe

    date reg hrs ot hrs
    3/07 8 1.5

    for job hours:

    bilbrey

    date worker hours
    3/07 john doe 4

    i've just barely got done with the entry for the names (so that it will distinguish if its a new entry, editing an old entry, or using an old entry. why? the division takes in new workers, but doesn't assign accounting ids till AFTER payroll. so, they don't know the employee's accounting id when they first enter their time sheet. they hire people from temp agencies, so they need to add new employees all the time.)

    sooo much fun

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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