Dear all,
After reviewing a response by Barry Houdini (Overtime calc on Timesheet), I kindly request help in slightly extending the case to consider the following thresholds:
Datime = start 06:00; end 19:00
Night-time = start 19:00; end 06:00
Single OT = start 06:00; end 00:00
Double OT = start 00:00; end 06:00
Shift length = 9:00
Using BH's example sample, with 2 cases, the following results are shown:
<tbody>
</tbody>
I trust I am not double-posting; if so please accept my apologies.
Your assistance will be highly appreciated.
Kind regards, DMurray3
After reviewing a response by Barry Houdini (Overtime calc on Timesheet), I kindly request help in slightly extending the case to consider the following thresholds:
Datime = start 06:00; end 19:00
Night-time = start 19:00; end 06:00
Single OT = start 06:00; end 00:00
Double OT = start 00:00; end 06:00
Shift length = 9:00
Using BH's example sample, with 2 cases, the following results are shown:
start | end | std day | std nght | OT Single | OT Dble | note |
18:00 | 07:00 | 1:00 | 8:00 | 01:00 | 03:00 | perfect!! |
08:00 | 20:00 | 9:00 | 0:00 | 02:00 | 01:00 | OT Single s/b 3; OT Dbl s/b 0. |
<tbody>
</tbody>
I trust I am not double-posting; if so please accept my apologies.
Your assistance will be highly appreciated.
Kind regards, DMurray3
Last edited: