K
KC8DCN
I'm working on a spreadsheet that the user wants one formula for figuring out
the average overtime worked per week (she wants to be able to copy and paste
it where needed).
Each person listed in the sheet has 1 row per pay period along with the
total amount of hours and total amount of hours worked overtime. Each person
has a different amount of rows, though. It's similar to
Date Person Name Total hours OT
01/01/01 Person name 50 10
01/20/01 Person Name 40 0
I have a general formula, but I can't figure out how to get it to adjust
itself according to the person. The formula also can't be that complicated.
Any ideas? Thanks!
the average overtime worked per week (she wants to be able to copy and paste
it where needed).
Each person listed in the sheet has 1 row per pay period along with the
total amount of hours and total amount of hours worked overtime. Each person
has a different amount of rows, though. It's similar to
Date Person Name Total hours OT
01/01/01 Person name 50 10
01/20/01 Person Name 40 0
I have a general formula, but I can't figure out how to get it to adjust
itself according to the person. The formula also can't be that complicated.
Any ideas? Thanks!