Timesheet differences

1. 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

2. 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??

3. 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.

4. Re: Timesheet differences

This is a sample there are over 500 entries so I need a way to automate it thanks
Thanks Patsy

5. 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. 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

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

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