Forum Discussion
Solved
Adding hidden values to a text and having them add up in a total box
Hi Guys, I'm a newby to advanced excel. I am doing rostering and I want to assign shifts to my employees but I don't want the hours visible. So they will be assigned as below. I woul...
Hi Shell78
- Renamed your Tables
- Added a ShiftCode/Hours Table
- Implemented formula to match Shift codes & Hours in daily Tables
- Implemented formula to report daily totals in Employee sheet
Updated workbook attached
