T
Tia
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
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