Spreadsheet: 57014d1257195370-different-factors-for-time-calculation-exampletime_comments
Sheet: Tabelle1

 |  |  |  |  |  |  |  |  |  |  |  |  | 00:01:00
 |  |  |  | Time 1 |  | Time 2 |  | Time 3 |  | Time 4 |  | 22:59:00 | 23:59:00 | 06:00:00
Day |  |  |  | Start | End | Start | End | Start | End | Start | End | Time1 Normal 6:00-22.59 | Time 1 23.00-23.59 x 1.25 | Time 0.00-05.59 x 1.5 | Total time 1 without extra hours | Total time 1 with extra hours | Time 2 | Time 3 | Time 4 | Total Time
Thursday | 1 |  |  | 23:10:00 | 23:30:00 |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:25:00 | 1900-01-01 00:00:00 | 00:20:00 | 00:25:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | #N/A
Friday | 2 |  |  | 23:30:00 | 23:50:00 |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:25:00 | 1900-01-01 00:00:00 | 00:20:00 | 00:25:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:20:00
Saturday | 3 |  |  | 23:00:00 | 23:59:00 |  |  |  |  |  |  | 1900-01-01 00:00:00 | 01:13:45 | 1900-01-01 00:00:00 | 00:59:00 | 01:13:45 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:59:00
Sunday | 4 |  |  | 22:00:00 | 23:30:00 |  |  |  |  |  |  | 01:28:30 | 00:45:00 | 1900-01-01 00:00:00 | 01:30:00 | 02:13:30 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:30:00
Monday | 5 |  |  | 22:00:00 | 23:00:00 |  |  |  |  |  |  | 00:59:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 00:59:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:00:00
Tuesday | 6 |  |  | 22:00:00 | 23:59:00 |  |  |  |  |  |  | 00:59:00 | 01:13:45 | 1900-01-01 00:00:00 | 01:59:00 | 02:12:45 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:59:00
Wednesday | 7 |  |  | 22:00:00 | 23:58:00 |  |  |  |  |  |  | 00:59:00 | 01:12:30 | 1900-01-01 00:00:00 | 01:58:00 | 02:11:30 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:58:00
Thursday | 8 |  |  | 22:00:00 | 23:20:00 |  |  |  |  |  |  | 00:59:00 | 00:25:00 | 1900-01-01 00:00:00 | 01:20:00 | 01:24:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:20:00
Friday | 9 |  |  | 22:00:00 | 23:40:00 |  |  |  |  |  |  | 00:59:00 | 00:50:00 | 1900-01-01 00:00:00 | 01:40:00 | 01:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:40:00
Saturday | 10 |  |  | 22:00:00 | 23:01:00 |  |  |  |  |  |  | 00:59:00 | 00:01:15 | 1900-01-01 00:00:00 | 01:01:00 | 01:00:15 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:01:00
Sunday | 11 |  |  | 05:00:00 | 12:00:00 |  |  |  |  |  |  | 09:00:00 | 1900-01-01 00:00:00 | 01:30:00 | 07:00:00 | 10:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 07:00:00
Monday | 12 |  |  | 23:40:00 | 01:00:00 |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:25:00 | 01:15:00 | 01:20:00 | 01:40:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 01:20:00
Tuesday | 13 |  |  | 22:00:00 | 01:00:00 |  |  |  |  |  |  | 00:59:00 | 01:16:15 | 01:15:00 | 03:00:00 | 03:30:15 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 03:00:00
Wednesday | 14 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Thursday | 15 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Friday | 16 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Saturday | 17 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Sunday | 18 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Monday | 19 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Tuesday | 20 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Wednesday | 21 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Thursday | 22 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Friday | 23 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Saturday | 24 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Sunday | 25 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Monday | 26 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Tuesday | 27 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Wednesday | 28 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Thursday | 29 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Friday | 30 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Saturday | 31 |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  | 23:00 to 23:59 | 00:00 to 6:00 | normal time
Monday - Friday: |  |  |  |  |  |  | Monday | 1.25 | 1.25 | 1 |  |  | Comment:
6.00 (Morning) - 23.00 Normal Time (no factor) |  |  |  |  |  |  | Tuesday | 1.25 | 1.25 | 1 |  |  | Tuesday 6 October until Saturday 10 October the result in N11-N15 Should have the opposite Value
23.00-5.59 = calculated time x 1.25 |  |  |  |  |  |  | Wednesday | 1.25 | 1.25 | 1
Saturday/Sunday: |  |  |  |  |  |  | Thursday | 1.25 | 1.25 | 1 |  |  | Correct
Saturday 6.00-22.59 = no factor |  |  |  |  |  |  | Friday | 1.25 | 1.25 | 1 |  |  | False
Saturday 23.00-23.59 = calculated time x 1.25 |  |  |  |  |  |  | Saturday | 1.25 | 1.25 | 1
Sunday 0.00-23.59 = calculated time x 1.5 |  |  |  |  |  |  | Sunday | 1.5 | 1.5 | 1.5
Monday 0.00-5.59 = calculated time x 1.25