View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emylie Emylie is offline
external usenet poster
 
Posts: 4
Default Help with Sick time accrual formula for pausing when a max isreached and resuming when time is used


Sick Available Hours Used Date of Used Accrued Sick Remaining
106.39 3.69 110.08
110.08 9.75 1/11- 1/12/17 3.69 104.02
104.02 3.69 107.71
107.71 3.69 111.4
111.4 12.5 2/22/, 3/1/17 3.69 102.59
102.59 2.75 3/6/2017 3.69 103.53
103.53 12.75 3/23, 3/31/17 3.69 94.47
94.47 3.69 98.16
98.16 8 4/17/2017 3.69 93.85
93.85 3.69 97.54
97.54 8 5/22/2017 3.69 93.23
93.23 3.69 96.92
96.92 3.69 100.61