Hi
I'm trying to create a Department Planner.
I need time in 15 mins interval for 24 hours horizontally on the header and employees name vertically. I need to be able to select the time interval for each employees. Also, I need to group employees based on their job profile. I also need a few footers to calculate totals.
For example
6:00 7:00 8:00 9:00 10:00 .............................n Total hrs worked
15 30 45 15 30 45 15 30 45 15 30 45 15 30 45
Group A - Emp1 highlight back color if working and if double clicked on a particular 15 mins interval then change the colour Total Emp1
Group A - Emp2
Group A - Emp3
:
Group A -Footer total...
Group B - Emp1
Group B - Emp2
:
Group B - Footer total
What' s the best control that I can use to achieve the above scenario.
Any suggestions would be appreciated.
Thanks
I'm trying to create a Department Planner.
I need time in 15 mins interval for 24 hours horizontally on the header and employees name vertically. I need to be able to select the time interval for each employees. Also, I need to group employees based on their job profile. I also need a few footers to calculate totals.
For example
6:00 7:00 8:00 9:00 10:00 .............................n Total hrs worked
15 30 45 15 30 45 15 30 45 15 30 45 15 30 45
Group A - Emp1 highlight back color if working and if double clicked on a particular 15 mins interval then change the colour Total Emp1
Group A - Emp2
Group A - Emp3
:
Group A -Footer total...
Group B - Emp1
Group B - Emp2
:
Group B - Footer total
What' s the best control that I can use to achieve the above scenario.
Any suggestions would be appreciated.
Thanks