G
Guest
I need to pay a shift differential for times worked as follows:
shift diff#1: Pay "X" if start time is from 1:00 p.m. through 8:59 p.m.
shift diff#2: Pay "X" if start time is from 9:00 p.m. through 2:59 a.m.
The time input sheet converts the start times to military time. Then I have
been trying to evaluate the start time for TRUE against the above statements.
If TRUE, then another cell calculates the total time X the shift diferential
and adds it to the total wages.
How do I write the function IF or AND for the shift diff#2.
shift diff#1: Pay "X" if start time is from 1:00 p.m. through 8:59 p.m.
shift diff#2: Pay "X" if start time is from 9:00 p.m. through 2:59 a.m.
The time input sheet converts the start times to military time. Then I have
been trying to evaluate the start time for TRUE against the above statements.
If TRUE, then another cell calculates the total time X the shift diferential
and adds it to the total wages.
How do I write the function IF or AND for the shift diff#2.