informatica complex question

[senthil45]

My input is below:

emp id day in time out time
3433 5000 8 AM 01:00 PM
3433 5000 02 PM 06:00 PM
3433 5001 8 AM 05:00 PM
3454 5000 08 AM 05:00 PM
3454 5001 08 AM 05:00 PM
3454 5002 5 AM 08 AM
3454 5002 09 AM 4 PM
3454 5002 4:05 PM 08 PM

Note: 5000- Monday, 5001-tuesday,5003-wednesday so on till 5007- sunday

Output Needed:

empid inand out time
3433 M-8AM to 06 PM,T-8AM to 05 PM
3454 M-T 8AM to 5PM,W-5AM to 8 PM

How can i implement the above scenario in transformation?