+ Reply to Thread
Results 1 to 6 of 6

Timesheet differences

  1. #1
    Registered User
    Join Date
    12-30-2011
    Location
    Oak Ridge TN
    MS-Off Ver
    Excel 2007
    Posts
    21

    Timesheet differences

    Need to look a the codes in column a and the employee id in column b and if the
    Code 1 = hours worked (total to be 80) so this one needs to change in other words it should equeal code 7 + code 4 - 80 = gives hours worked I just can't figure out how to put it togeather thanks
    Code 4 = pto time
    Code 7 = Holiday which is 8.
    how can I get it to look at all and give me a total thanks
    I have included the file
    Last edited by patsyhixon; 01-16-2012 at 11:35 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Timesheet differences

    Hi and welcome to the forum.

    For me is not clear the result that you want.

    Pls tell me, in H3:H7, which are the corect results??
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    12-30-2011
    Location
    Oak Ridge TN
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Timesheet differences

    So sorry, I need the spreadsheet to look at the Codes in Column A and add Code 7 + Code 4 and that total to subtract 80 to give me the salary hours. Code 2 is always 0. The employee id is how you tell the employee total. Does that make sense? I have to do this every payday it is hard doing it the way I was so I was hoping for help. The total needs to be 80.

    code7+code4-80=salary hours


    I have been putting =80-the cell the hours are in but the 1, 4, and 7 codes are not always in order.

    IF empoyee 15116 had 4 hours pto (code4) and 8 hours holiday (code 7) then the result for salary hours would be 68
    I hope this helps, cause I need help.
    Last edited by patsyhixon; 12-30-2011 at 12:52 PM.

  4. #4
    Registered User
    Join Date
    12-30-2011
    Location
    Oak Ridge TN
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Timesheet differences

    This is a sample there are over 500 entries so I need a way to automate it thanks
    Thanks Patsy
    Attached Files Attached Files
    Last edited by patsyhixon; 01-03-2012 at 10:03 AM. Reason: adding sample spreadsheet

  5. #5
    Registered User
    Join Date
    12-30-2011
    Location
    Oak Ridge TN
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Timesheet differences

    Anyone have any ideals how to make this so I do not have to manually enter the formula each time. I was thinking vlookup but could not get it to work as the PTO hours change from payday to payday.

  6. #6
    Registered User
    Join Date
    12-30-2011
    Location
    Oak Ridge TN
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Timesheet differences

    To write an IF statement to change the number of hours by adding code7 and code4 and subtracting those from 80 to give the number hours. 80 hours is the total as they are salary employees. I have been able to do this by creating a sinple formula but can not figure out how to use the if statement to give me what I need, Thanks

+ 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