Timesheet differences

[patsyhixon]

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

[Fotis1991]

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

[patsyhixon]

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.

[patsyhixon]

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

[patsyhixon]

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.

[patsyhixon]

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