Now obviously people may start their employment at different times of the year, which is why the complicated function is necessary in trying to get their total hours worked. One of the main functions is to calculate Holiday pay based on the number of hours worked. The reason I am asking this, is because this is a cutdown version of my company's weekly payroll calculation. Not that makes it any difference to the main point. The previous reference to AR7 was incorrect, it should have been AQ7. It now includes a third sheet to show an employee starting on a different date so that the formula in the Holiday sheet becomes a bit more relevant. I have revised the file, and corrected an error. ![]() I'm not sure how I would do this in Numbers, especially in a way that would also work in Excel. It appears what you want to do is add up cell AR7 of each worksheet whose name is within the range of dates given by columns H and I.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |