L
LUIS CORDERO
looking for someone to help me with this one.
this is what i'm trying to do on excel. Cell a1 is the employee's name
and cell b1 is the hire date. I would like to get the formula to first
determine total days the employee has worked up until present and then
to put into cell C1 IF THE EMPLOYEE HAS WORKED 1 WHOLE YEAR (365 DAYS)
put in cell C1 (40 HOURS) IF THE EMPLOYEE HAS WORDED 3 YEARS (1095
DAYS) PUT IN CELL C1 (80 HOURS) AND IF THE EMPLOYEE HAS WORDED 10
YEARS (3650 DAYS) PUT IN CELL C1 (120 HOURS) IN DOING THIS WHAT I WANT
TO BE ABLE TO SEE ON THE WOOK BOOK IS THE EMPLOYEE NAME ON A1 DATE OF
HIRE ON B1 AND THE CALCULATION OF HOW MANY HOURS OF vacation the
employee is intitled to.
WOULD GREATLY APPRECIATE ANY HELP ANYONE CAN OFFER
THANKS
this is what i'm trying to do on excel. Cell a1 is the employee's name
and cell b1 is the hire date. I would like to get the formula to first
determine total days the employee has worked up until present and then
to put into cell C1 IF THE EMPLOYEE HAS WORKED 1 WHOLE YEAR (365 DAYS)
put in cell C1 (40 HOURS) IF THE EMPLOYEE HAS WORDED 3 YEARS (1095
DAYS) PUT IN CELL C1 (80 HOURS) AND IF THE EMPLOYEE HAS WORDED 10
YEARS (3650 DAYS) PUT IN CELL C1 (120 HOURS) IN DOING THIS WHAT I WANT
TO BE ABLE TO SEE ON THE WOOK BOOK IS THE EMPLOYEE NAME ON A1 DATE OF
HIRE ON B1 AND THE CALCULATION OF HOW MANY HOURS OF vacation the
employee is intitled to.
WOULD GREATLY APPRECIATE ANY HELP ANYONE CAN OFFER
THANKS