Results 1 to 6 of 6

Timesheet differences

Threaded View

patsyhixon Timesheet differences 12-30-2011, 10:20 AM
Fotis1991 Re: Timesheet differences 12-30-2011, 11:37 AM
patsyhixon Re: Timesheet differences 12-30-2011, 12:32 PM
patsyhixon Re: Timesheet differences 01-10-2012, 12:07 PM
patsyhixon Re: Timesheet differences 01-03-2012, 09:48 AM
patsyhixon Re: Timesheet differences 01-05-2012, 11:10 AM
  1. #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.

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