Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Sheet Problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Sheet Problem
How about
=SUM(E3:AI3)/8+3-COUNTIF(E3:AI3,"A") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Rao Ratan Singh" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Sheet Problem
Thank you bob.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet determination of what day and time rate | Excel Worksheet Functions | |||
Problem created by sorting linked sheet | Excel Discussion (Misc queries) | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Problem with calculating time | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions |