Timesheet sample.xlsxI have a time sheet that we are working but are often asked to compile data from it. We have most of the bugs worked out.
The biggest issues now is to Average hours for the pay cycle. In our "Timesheet Sample" We can average each week (thanks FDibbins) as in the case of "Billy Bob" and we created a formula to average the 3 weeks that it spans, but as in the case of "Billy Jean's" she did not work one day each week so the formula gags on dividing zero.
I need help in creating another formula that accounts for the average hours worked base on the days the worked not just the total days of the week. This is accomplished each week but when I cross from week to week it is not working out.
All assistance is appreciated.
Bookmarks