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.
[TABLE="width: 89"]
<tbody>[TR]
[TD="class: xl63, width: 119, bgcolor: transparent"]dec_DecisionDate
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:14
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:21
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:26
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:31
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:36
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:39
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:43
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:50
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:59
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:05
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:13
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:32
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:38
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:41
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:46
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:50
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:51
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:56
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:03
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:03
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:04
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:07
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:09
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:14
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 89"]
<tbody>[TR]
[TD="class: xl63, width: 119, bgcolor: transparent"]dec_DecisionDate
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:14
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:21
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:26
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:31
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:36
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:39
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:43
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:50
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 6:59
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:05
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:13
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:32
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:38
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:41
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:46
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:50
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:51
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 7:56
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:03
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:03
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:04
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:07
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:09
[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]10/1/2017 8:14
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: