Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing Times
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Times | New Users to Excel | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) |