Spreadsheet: 775335d1649036437-calculate-pay-rate-depending-on-the-time-of-day-weekly-time-sheet-help
Sheet: Sheet6

 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:25:00 |  | 0.25
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:25:00 |  | 0.25
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:25:00 |  | 0.25
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:25:00 |  | 0.25
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:41:00 |  | 0.41
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:19:00 |  | 0.19
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:31:00 |  | 0.31
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:31:00 |  | 0.31
 |  |  |  |  |  | 00:32:00 |  | 0.32
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:32:00 |  | 0.32
 |  |  |  |  |  | 00:25:00 |  | 0.25
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:24:00 |  | 0.24
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:22:00 |  | 0.22
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:14:00 |  | 0.14
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:19:00 |  | 0.19
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:12:00 |  | 0.12
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:07:00 |  | 0.07
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:19:00 |  | 0.19
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:17:00 |  | 0.17
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:08:00 |  | 0.08
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:18:00 |  | 0.18
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:16:00 |  | 0.16
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:11:00 |  | 0.11
 |  |  |  |  |  | 00:21:00 |  | 0.21
 |  |  |  |  |  | 00:20:00 |  | 0.2
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:23:00 |  | 0.23
 |  |  |  |  |  | 00:10:00 |  | 0.1
 |  |  |  |  |  | 00:09:00 |  | 0.09
 |  |  |  |  |  | 00:15:00 |  | 0.15
 |  |  |  |  |  | 00:13:00 |  | 0.13
 |  |  |  |  |  | 00:21:00 |  | 0.21