Hi all, I am trying to calculate shift rates depending on times. I have the following shift rates, but I cannot seem to get the results returned I'm looking for due to the times of some shifts going past midnight.
As an example a shift might be 15:30 - 01:30.
<colgroup><col width="145" span="5" style="width:109pt"> </colgroup><tbody>
</tbody>
Any help would be greatly appreciated.
Regards
As an example a shift might be 15:30 - 01:30.
START BETWEEN | ||||
EARLY MORNING | 04:00 | 05:30 | ||
STARTS BEFORE | ENDS AFTER | |||
AFTERNOON | 18:00 | 18:30 | ||
START BETWEEN | ||||
NIGHT | 18:00 | 3:59 |
<colgroup><col width="145" span="5" style="width:109pt"> </colgroup><tbody>
</tbody>
Any help would be greatly appreciated.
Regards