Tricky Time Calculation

  • Thread starter Thread starter Laure Moody
  • Start date Start date
L

Laure Moody

Hi, and thanks in advance for light shed on this . . .

I have a situation where there are three levels of pay possible, (Regular,
Shift Differential 1, and Shift Differential2), where there is one rate for
0:00 - 06:00, another for 06:00 - 18:00, and a third for 18:00 - 24:00. I
would like to have some way to compare and calculate these hours, to apply
the corrected pay rate. Nested IF statements are driving me a bit nuts at
the moment, so any and alll help or links will be appreciated.
 
Some questions.

Is the actual differential determined by what shift the workday starts in?
OR
If the workday spans different shifts, is each minute worked in each shift
paid that shift's differential?
OR
Is the time span across shifts paid in increments (ie ...1/4 hour), instead
of individual minutes?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


Hi, and thanks in advance for light shed on this . . .

I have a situation where there are three levels of pay possible, (Regular,
Shift Differential 1, and Shift Differential2), where there is one rate for
0:00 - 06:00, another for 06:00 - 18:00, and a third for 18:00 - 24:00. I
would like to have some way to compare and calculate these hours, to apply
the corrected pay rate. Nested IF statements are driving me a bit nuts at
the moment, so any and alll help or links will be appreciated.
 
Back
Top