franciscloete1
New Member
- Joined
- Aug 23, 2018
- Messages
- 6
Hi there. I need tot get the value that is between a set of times. need to get the times that fall in the time bracket 8:15 to 9:20 from the (start time)
Also it must only reflect the time (Break times) longer than 35min within the time parameters of 8:15 to 9:2
The second is the time bracket 11:30 to 2:30 from the (start time)and this must be only where the (break time) is loner than 40min within the time parameters of 8:15 to 9:2
<colgroup><col style="mso-width-source:userset;mso-width-alt:2267;width:47pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
[TD="width: 62"]End time[/TD]
[TD="width: 74"]Break time[/TD]
[TD="width: 68"]Start time
[/TD]
[TD="class: xl65, align: right"]07:00:07[/TD]
[TD="class: xl66, align: right"]00:27:08[/TD]
[TD="class: xl67, align: right"]06:32:59[/TD]
[TD="class: xl65, align: right"]07:33:35[/TD]
[TD="class: xl66, align: right"]00:06:56[/TD]
[TD="class: xl67, align: right"]07:26:39[/TD]
[TD="class: xl65, align: right"]08:42:37[/TD]
[TD="class: xl66, align: right"]00:08:44[/TD]
[TD="class: xl67, align: right"]08:33:53[/TD]
[TD="class: xl65, align: right"]09:41:18[/TD]
[TD="class: xl66, align: right"]00:30:18[/TD]
[TD="class: xl67, align: right"]09:11:00[/TD]
[TD="class: xl65, align: right"]10:25:00[/TD]
[TD="class: xl66, align: right"]00:34:20[/TD]
[TD="class: xl67, align: right"]09:50:40[/TD]
[TD="class: xl65, align: right"]10:42:52[/TD]
[TD="class: xl66, align: right"]00:06:33[/TD]
[TD="class: xl67, align: right"]10:36:19[/TD]
[TD="class: xl65, align: right"]10:54:08[/TD]
[TD="class: xl66, align: right"]00:06:03[/TD]
[TD="class: xl67, align: right"]10:48:05[/TD]
[TD="class: xl65, align: right"]11:16:13[/TD]
[TD="class: xl66, align: right"]00:11:23[/TD]
[TD="class: xl67, align: right"]11:04:50[/TD]
[TD="class: xl65, align: right"]11:48:36[/TD]
[TD="class: xl66, align: right"]00:18:01[/TD]
[TD="class: xl67, align: right"]11:30:35
[/TD]
[TD="class: xl65, align: right"]12:13:46[/TD]
[TD="class: xl66, align: right"]00:11:51[/TD]
[TD="class: xl67, align: right"]12:01:55[/TD]
[TD="class: xl65, align: right"]12:52:27[/TD]
[TD="class: xl66, align: right"]
<colgroup><col width="74"></colgroup><tbody>
[TD="class: xl65, width: 74, align: right"]00:45:19[/TD]
</tbody>
[/TD]
[TD="class: xl67, align: right"]
<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl65, width: 64, align: right"]12:07:08[/TD]
</tbody>
[/TD]
[TD="class: xl65, align: right"]14:33:49[/TD]
[TD="class: xl66, align: right"]01:15:13[/TD]
[TD="class: xl67, align: right"]13:18:36[/TD]
[TD="class: xl65, align: right"]14:42:01[/TD]
[TD="class: xl66, align: right"]00:08:12[/TD]
[TD="class: xl67, align: right"]14:33:49[/TD]
[TD="class: xl65, align: right"]15:11:59[/TD]
[TD="class: xl66, align: right"]00:05:07[/TD]
[TD="class: xl67, align: right"]15:06:52[/TD]
[TD="class: xl65, align: right"]15:28:27[/TD]
[TD="class: xl66, align: right"]00:14:00[/TD]
[TD="class: xl67, align: right"]15:14:27[/TD]
[TD="class: xl65, align: right"]15:46:25[/TD]
[TD="class: xl66, align: right"]00:07:48[/TD]
[TD="class: xl67, align: right"]15:38:37[/TD]
[TD="class: xl65, align: right"]16:08:09[/TD]
[TD="class: xl66, align: right"]00:12:45[/TD]
[TD="class: xl67, align: right"]15:55:24[/TD]
[TD="class: xl65, align: right"]16:34:41[/TD]
[TD="class: xl66, align: right"]00:13:23[/TD]
[TD="class: xl67, align: right"]16:21:18[/TD]
</tbody>
Also it must only reflect the time (Break times) longer than 35min within the time parameters of 8:15 to 9:2
The second is the time bracket 11:30 to 2:30 from the (start time)and this must be only where the (break time) is loner than 40min within the time parameters of 8:15 to 9:2
<colgroup><col style="mso-width-source:userset;mso-width-alt:2267;width:47pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> </colgroup><tbody>
[TD="width: 62"]End time[/TD]
[TD="width: 74"]Break time[/TD]
[TD="width: 68"]Start time
[/TD]
[TD="class: xl65, align: right"]07:00:07[/TD]
[TD="class: xl66, align: right"]00:27:08[/TD]
[TD="class: xl67, align: right"]06:32:59[/TD]
[TD="class: xl65, align: right"]07:33:35[/TD]
[TD="class: xl66, align: right"]00:06:56[/TD]
[TD="class: xl67, align: right"]07:26:39[/TD]
[TD="class: xl65, align: right"]08:42:37[/TD]
[TD="class: xl66, align: right"]00:08:44[/TD]
[TD="class: xl67, align: right"]08:33:53[/TD]
[TD="class: xl65, align: right"]09:41:18[/TD]
[TD="class: xl66, align: right"]00:30:18[/TD]
[TD="class: xl67, align: right"]09:11:00[/TD]
[TD="class: xl65, align: right"]10:25:00[/TD]
[TD="class: xl66, align: right"]00:34:20[/TD]
[TD="class: xl67, align: right"]09:50:40[/TD]
[TD="class: xl65, align: right"]10:42:52[/TD]
[TD="class: xl66, align: right"]00:06:33[/TD]
[TD="class: xl67, align: right"]10:36:19[/TD]
[TD="class: xl65, align: right"]10:54:08[/TD]
[TD="class: xl66, align: right"]00:06:03[/TD]
[TD="class: xl67, align: right"]10:48:05[/TD]
[TD="class: xl65, align: right"]11:16:13[/TD]
[TD="class: xl66, align: right"]00:11:23[/TD]
[TD="class: xl67, align: right"]11:04:50[/TD]
[TD="class: xl65, align: right"]11:48:36[/TD]
[TD="class: xl66, align: right"]00:18:01[/TD]
[TD="class: xl67, align: right"]11:30:35
[/TD]
[TD="class: xl65, align: right"]12:13:46[/TD]
[TD="class: xl66, align: right"]00:11:51[/TD]
[TD="class: xl67, align: right"]12:01:55[/TD]
[TD="class: xl65, align: right"]12:52:27[/TD]
[TD="class: xl66, align: right"]
<colgroup><col width="74"></colgroup><tbody>
[TD="class: xl65, width: 74, align: right"]00:45:19[/TD]
</tbody>
[TD="class: xl67, align: right"]
<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl65, width: 64, align: right"]12:07:08[/TD]
</tbody>
[TD="class: xl65, align: right"]14:33:49[/TD]
[TD="class: xl66, align: right"]01:15:13[/TD]
[TD="class: xl67, align: right"]13:18:36[/TD]
[TD="class: xl65, align: right"]14:42:01[/TD]
[TD="class: xl66, align: right"]00:08:12[/TD]
[TD="class: xl67, align: right"]14:33:49[/TD]
[TD="class: xl65, align: right"]15:11:59[/TD]
[TD="class: xl66, align: right"]00:05:07[/TD]
[TD="class: xl67, align: right"]15:06:52[/TD]
[TD="class: xl65, align: right"]15:28:27[/TD]
[TD="class: xl66, align: right"]00:14:00[/TD]
[TD="class: xl67, align: right"]15:14:27[/TD]
[TD="class: xl65, align: right"]15:46:25[/TD]
[TD="class: xl66, align: right"]00:07:48[/TD]
[TD="class: xl67, align: right"]15:38:37[/TD]
[TD="class: xl65, align: right"]16:08:09[/TD]
[TD="class: xl66, align: right"]00:12:45[/TD]
[TD="class: xl67, align: right"]15:55:24[/TD]
[TD="class: xl65, align: right"]16:34:41[/TD]
[TD="class: xl66, align: right"]00:13:23[/TD]
[TD="class: xl67, align: right"]16:21:18[/TD]
</tbody>