I have a column in an Excel spreadsheet that lists the date and time in military time. An employee works 7:00am to 3:30pm. I want to sort the time worked each day (7:00 to 3:30) for the employee each day and exclude the time worked, 3:31pm to 6:59am. Can this be done without doing it manually using sorting or a filter? See column below.
<tbody>
</tbody>
dec_DecisionDate |
10/1/2017 6:14 |
10/1/2017 6:21 |
10/1/2017 6:26 |
10/1/2017 6:31 |
10/1/2017 6:36 |
10/1/2017 6:39 |
10/1/2017 6:43 |
10/1/2017 6:50 |
10/1/2017 6:59 |
10/1/2017 7:05 |
10/1/2017 7:13 |
10/1/2017 7:32 |
10/1/2017 7:38 |
10/1/2017 7:41 |
10/1/2017 7:46 |
10/1/2017 7:50 |
10/1/2017 7:51 |
10/1/2017 7:56 |
10/1/2017 8:03 |
10/1/2017 8:03 |
10/1/2017 8:04 |
10/1/2017 8:07 |
10/1/2017 8:09 |
10/1/2017 8:14 |
<tbody>
</tbody>
Last edited: