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.
[TABLE="width: 725"]
<colgroup><col width="145" span="5" style="width:109pt"> </colgroup><tbody>[TR]
[TD="width: 145"][/TD]
[TD="class: xl66, width: 290, colspan: 2"]START BETWEEN[/TD]
[TD="width: 145"][/TD]
[TD="width: 145"][/TD]
[/TR]
[TR]
[TD]EARLY MORNING[/TD]
[TD="class: xl63"]04:00[/TD]
[TD="class: xl63"]05:30[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STARTS BEFORE[/TD]
[TD]ENDS AFTER[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AFTERNOON[/TD]
[TD="class: xl64"]18:00[/TD]
[TD="class: xl64"]18:30[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl66, colspan: 2"]START BETWEEN[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]NIGHT[/TD]
[TD="class: xl64"]18:00[/TD]
[TD="class: xl64"]3:59[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help would be greatly appreciated.
Regards
As an example a shift might be 15:30 - 01:30.
[TABLE="width: 725"]
<colgroup><col width="145" span="5" style="width:109pt"> </colgroup><tbody>[TR]
[TD="width: 145"][/TD]
[TD="class: xl66, width: 290, colspan: 2"]START BETWEEN[/TD]
[TD="width: 145"][/TD]
[TD="width: 145"][/TD]
[/TR]
[TR]
[TD]EARLY MORNING[/TD]
[TD="class: xl63"]04:00[/TD]
[TD="class: xl63"]05:30[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]STARTS BEFORE[/TD]
[TD]ENDS AFTER[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AFTERNOON[/TD]
[TD="class: xl64"]18:00[/TD]
[TD="class: xl64"]18:30[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl66, colspan: 2"]START BETWEEN[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]NIGHT[/TD]
[TD="class: xl64"]18:00[/TD]
[TD="class: xl64"]3:59[/TD]
[TD="class: xl65, align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any help would be greatly appreciated.
Regards