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>
</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
End time | Break time | Start time | ||
07:00:07 | 00:27:08 | 06:32:59 | ||
07:33:35 | 00:06:56 | 07:26:39 | ||
08:42:37 | 00:08:44 | 08:33:53 | ||
09:41:18 | 00:30:18 | 09:11:00 | ||
10:25:00 | 00:34:20 | 09:50:40 | ||
10:42:52 | 00:06:33 | 10:36:19 | ||
10:54:08 | 00:06:03 | 10:48:05 | ||
11:16:13 | 00:11:23 | 11:04:50 | ||
11:48:36 | 00:18:01 | 11:30:35 | ||
12:13:46 | 00:11:51 | 12:01:55 | ||
12:52:27 |
<colgroup><col width="74"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||
14:33:49 | 01:15:13 | 13:18:36 | ||
14:42:01 | 00:08:12 | 14:33:49 | ||
15:11:59 | 00:05:07 | 15:06:52 | ||
15:28:27 | 00:14:00 | 15:14:27 | ||
15:46:25 | 00:07:48 | 15:38:37 | ||
16:08:09 | 00:12:45 | 15:55:24 | ||
16:34:41 | 00:13:23 | 16:21:18 |
<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>
</tbody>