Sorting Time

[Bernard2]

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.

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>

 

[Bernard2]

Couldn't edit title of thread. But I wanted to filter the time, 7:00am to 3:30pm, each day from column.

 

[Bernard2]

Well, I guess the answer is no.

 

[shg]

I think it's a safe bet no one knows what you're trying to do. An example output might help.