I have employee take leave report like that:
I want to sum time in each group.
(#Group ABC Company)
AL
|
SL
|
SIL
|
ML
|
8:00
|
12:45
|
10:00
|
4:30
|
8:15
|
34:35
|
8:00
|
5:50
|
(#Group XYZ Company)
AL
|
SL
|
SIL
|
ML
|
5:00
|
6:00
|
20:50
|
0:00
|
8:00
|
16:45
|
8:20
|
8:00
|
8:00
|
7:00
|
2:00
|
12:00
|
I want to get result like that:
(#Group ABC Company)
AL
|
SL
|
SIL
|
ML
|
8:00
|
12:45
|
10:00
|
4:30
|
8:15
|
34:35
|
8:00
|
5:50
|
16:15 47:20 18:00 10:20
(#Group XYZ Company)
AL
|
SL
|
SIL
|
ML
|
5:00
|
6:00
|
20:50
|
0:00
|
8:00
|
16:45
|
8:20
|
8:00
|
8:00
|
7:00
|
2:00
|
12:00
|
21:00 29:45 31:10 20:00
and in the report have many group.
Thank in Advance!