Time and Date Sum w/ auto filter

[Newbienew]

I have a vacation tracker for work, that always me to see when people start and return from vacation or other time off situations. The issue that I am having is two parts. Main one: I have figured out how to calculate the days between days by using b2-a1, but I have to incorporate the times. So if they start at 0900 then that is a day used but if they start at 1800 that day is not used. This makes a world of difference. Below is my visual example.

The cells in with the "V" are the ones counted just for visual reasons. This is not how the sheet actually looks.

Left before the worday started, this day counts						Returned after the work day , this day is counted
900	V 24-Aug-18	V 25	V 26	V 27	V 28	V 29	1800	V 30-Aug-18	7
Left after the work day, this day does not count						Returned before the word day started, day not counted
1800	V 24-Aug-18	V 25	V 26	V 27	V 28	V 29	900	30-Aug-18	5
Left before the work day started, this day counts						Returned before the work day started, day not counted
900	V 24-Aug-18	V 25	V 26	V 27	V 28	V 29	900	30-Aug-18	6
Left after the work day, this day is not counted						Returned After the work day, this day is counted
1800	24-Aug-18	V 25	V 26	V 27	V 28	V 29	1800	V 30-Aug-18	6

<colgroup><col style="width:50pt" width="67"> <col style="mso-width-source:userset;mso-width-alt:2937; width:65pt" width="87" span="2"> <col style="mso-width-source:userset;mso-width-alt:3651;width:81pt" width="108"> <col style="width:50pt" width="67" span="6"> </colgroup><tbody>
</tbody>

<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { border: 0.5pt solid windowtext; background: rgb(146, 208, 80) none repeat scroll 0% 0%; }.xl66 { border: 0.5pt solid windowtext; background: rgb(146, 208, 80) none repeat scroll 0% 0%; }.xl67 { }.xl68 { border: 0.5pt solid windowtext; background: white none repeat scroll 0% 0%; }.xl69 { border: 0.5pt solid windowtext; background: white none repeat scroll 0% 0%; }</style>





Part two as well as what the section of the sheet looks like is, I would like for it to auto shuffle the rows according to who comes back the earliest. There for it makes it easier to delete them from the bottom of the list. If it could be a macro button that would work out if possible

time	date	time	date	number of days
900	24-Aug-18	1800	30-Aug-18	formula
1800	24-Aug-18	900	31-Aug-18	formula
900	24-Aug-18	900	1-Sep-18	formula
1800	24-Aug-18	1800	2-Sep-18	formula

<tbody>
</tbody>

<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { border: 0.5pt solid windowtext; }.xl66 { border: 0.5pt solid windowtext; }.xl67 { border: 0.5pt solid windowtext; background: rgb(255, 192, 0) none repeat scroll 0% 0%; }</style>

I truly hope this is not as confusing or complicated as i am making it. Thank you to any one that can help.

 

[Newbienew]

1800 V 24 AUG 2018 Should not have a V there, typo

 

[Newbienew]

Revisiting thread to hopefully get some help. thank You.