Gouping the value with from and to date.

[sachinviki]

Dear Experts,

Really first of all i would like to appreciate all the experts here, whenever the question is been raised the response will be immediate or max to max within a day solution will be given.

Here i have come up with an query too..

No	From	To	Attd. Type	Start Time	End Time
100278	19-07-2017	19-07-2017	A/B
100278	20-07-2017	20-07-2017	A
100278	21-07-2017	21-07-2017	B/A
100278	22-07-2017	22-07-2017	A
100278	23-07-2017	23-07-2017	A
100278	24-07-2017	24-07-2017	A

<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

This is my existing data.

i want the format like below..

1. if A/B which ever comes before / it will be 09:30 to 13:30
2. if A/B which ever comes after / it will be 13:30 to 18:30 (actually there are more than two variables here i have given only two)
3. if there is an "A" continuously from 1-30th or 1-31st then it should be grouped as

100278 01-07-2017 to 31-07-2017 A


this is my requirement. can anybody help me out?