![]() ![]() This approach is easier to put together and easier to diagnose issues with as you are working on it. Then in the next column you see I merged the cells next these subtotals, and wrote a 'sum' formula to total the subtotals for each shift totals in column J. ![]() To do so you will use the 'countif' function for each shift for each person (the range is the whole calendar and the, then multiply by the corresponding number of hours per shift on the 2nd page. The first way is the simpler way that makes each calculation individually and then totals them on the back end. I recreated a basic version of what you have pictured above and then put together two different methods for calculating the total hours per week per employee based on the schedule. I made one just like it a couple of years ago but will additional reporting pages that would break down the total hours by standard pay, OT pay, and holiday pay, then with that information calculate their gross pay. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |