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!

You don't say how your calendar is laid out but for a count of the sick days
try something like:

=COUNTIF(B2:H6,"S")

and for time:

=COUNTIF(B2:H6,"S")*TIME(8,,)
and format the cell as [h]:mm

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Tami" wrote in message
...
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!