In my agency, we accrue 3.69 hours of sick time per paycheck, for a total of 96 hours over 26 paychecks. Starting on the SHIFT sheet, I have a drop-down list for employees listed on the MASTER sheet which will reference a date of hire (C2:C24 for example). If I want to determine 1) total accruals since date of hire (F) and 2) total accruals for the year to date (G), what would the calculations be? I realize that for my second request, I would probably also (I think) need to know the date of the first paycheck for that year in order to determine how many paychecks have gone out since the beginning of the year. I will be doing a sick time analysis which will determine the difference between what they have and what they should have.
Thank you in advance!!
Bookmarks