Calculate Field for Sick Time

C

Connie

I am trying to create a field on a form that will
calculate sick time at 5 hours per month, up to 40 hours
(no more)per year. The beginning of the accumulation
would always start Jan of the current year, therefore, all
sick time accumulated in the prior year needs to be zero'd
out if not used - OR - Sick time could be "rolled" over if
it is less than 40 hrs and accumulate UP TO 40 hrs. if it
gets used.

After creating this field, I need to perform a subtraction
calculation based on usage. (I already have the sick time
used totaling - so now I need to get the field to
accumulate sick time - then I can create a field to
subtract the two. HELP!
Thanks,
Connie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating Sick pay entitlement 2
Calculating occupational sick pay entitlement 0
if statement = if number is between 1
non-numeric in a calculation 1
Calculating regular time, subtracting any personal time 5
sick time usage 4
Calculate leave time in a query 4
Calc staff vacation time based on more than 1 criteria 0

Top