If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Statutory Hrs Calculation
I have a payroll timesheet tracking hours worked, with rows corresponding to the names of employees and columns corresponding to dates of the pay period (14 days in each pay period). Each pay period is currently stored as a separate worksheet, e.g. Oct1 for the first pay period of October, then Oct2, Nov1, etc. What I'm trying to do is create a function that would check if there is a "STAT" word above each date. If yes, then count the nonzero cells in 30 days preceding the STAT date, and if count is = 15, sum all values in those 30 cells. What is the best way to do it? I thought of combining the worksheets into one containing 44 days and carrying forward the 44-day cut off as the first step. Do I need to do that? Thank you. |
Thread Tools | |
Display Modes | |
|
|