Attendance formula for payroll please help
Hello,
I am working a attendance and payroll sheet i have one sheet called "programm" that i update the date each month 30 or 31 days every working day is 09:00:00 working hours in and it will automaticly updated in each employee sheet and all days are considered as working days no days off My Attendance sheet for each employee is as follows The problem is that i am working in a restaurant and every person has a different day off based on the schedule A3 = Dates B3= Present 1/ Absent 0 (=COUNT(G3) C3= If Absent write A D3= Annual Write AN E3= Sick Write S F3= Off Days Write G3= Time In H3=Time OUT K3= Total Hours (+H3-G3) L3= required Hours (+Programm) What i am looking for : if any of the Cells in C3:F3 equal to a name or not empty ,put the total required hours in Cell L3 as 0:00:00(time) but if there is attendance in Cells G3 and H3 take the required hours from the program Example : L3= +Program!C3 Please advise |
All times are GMT +1. The time now is 01:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com