Formulas
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! |
Formulas
Sort your table by person, then apply Subtotals and choose Person from the
Group by list, Average from the function to apply list in Subtotals Dialog. Regards, Stefi "KC8DCN" wrote: 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! |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com