I am creating an attendance tracking worksheet, when someone calls out sick
they can use sicktime so they can get paid and they receive an occurence. I
need to be albe to enter a code for the event on the calendar, say "S" for
sick, and then have a totals section count 1 occurance and 8 hours of pay.
There are 2 seperate boxes for the totals, one for time used one for number
of occurences. Is there such a formula? Thanks!