Need macro for following condition

Hello,


I need help on the following condition.

ID Type Time
1 A 2
1 B 3
2 C 1.25
2 D 2
3 E 3

output

ID Type Time Day
1 A,B 5 1
2 C,D 3 1

2 C (or D) 0.25 2
3 E 3 2


The idea is i have an ID (1,2,...) which has many type (A,B,C....) and each type has been completed in some time (2,3....).

My output is i need a consolidated report which has 8 hrs per day. I have to select the first 8 hrs of time and fill per day. If time exceeds 8 (8.25 this case) the extra hrs should be carrid to next day. For each day the all types should come under single ID.

Please provide me a macro code. Thanks in advance.