Time Sheet Problem

G

Guest

Sir/Madam,
I have a worksheet to for employees working in my company. in E3:AI3 is
absent =A or present =8. 8 is for working hour.

I have calculated working hours by using this forumula =SUM(e3:AI3)/8.

But problem is Total Payble Leave is 3 days for employees. If someone
of them taken leave for five days, then how i get totak days of working.
and if someone did not used any leave then it should be added in total
working hours.

Thanks and regards

RRS
 
B

Bob Phillips

How about

=SUM(E3:AI3)/8+3-COUNTIF(E3:AI3,"A")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

But not working properly 2
Need formula Help. 6
Determine if night shift by start & end time 2
Total Working hours If 2
time sheet needed to total weekly hours worked by staff 1
How to set up a formula that it adds value on a certain date 5
Showing results in cell using formulas 1
Calculating hours 3

Top