Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation | Excel Discussion (Misc queries) | |||
Calculation using IF | Excel Worksheet Functions | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |