Forum Discussion
Solved
how to automate a payroll sheet?
I am trying to automate a sheet that I can enter in the model of the part and the amount and let it do the math on the hours worked. For example, if I assemble 100 pieces of the model "011" that is c...
You need to grant edit access to that Google sheet if you expect help.
What you're asking is very easy in a spreadsheet. I'd create a table in which the formula would seek how much time to allocate to each unit of whatever model it is, and then use VLOOKUP to retrieve that.
What's not clear is what Tuesday has to do with it as compared to other days of the week.
You need to grant edit access to that Google sheet if you expect help.
What you're asking is very easy in a spreadsheet. I'd create a table in which the formula would seek how much time to allocate to each unit of whatever model it is, and then use VLOOKUP to retrieve that.
What's not clear is what Tuesday has to do with it as compared to other days of the week.
my apologies, the permission is updated, as to why Tuesday, the work week ends Tuesday; however many parts of various models is done is recorded and then sent to the accounting firm to be paid to that employee. for example, if someone does 400 "011" parts from Wednesday 3/30/2022 to Saturday 4/2/2022 the amount would be 32 hours and that number will be sent to the accounting firm that following Tuesday 4/5/2022 and the employee would be direct deposited on Friday 4/8/2022. hopefully I have made that make more sense, and thanks in advance for the help.