I need a formula

T

Tami

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!
 
S

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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

Top