Forum Discussion
Shell78
Apr 26, 2022Copper Contributor
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 would like the shift codes to have an underlying value and add up to the amount of daily hours in the total box, then I want the hours to be carried over to another sheet with the weeks hours.
Does this make sense?
Can someone help me please?
https://1drv.ms/x/s!AiwNo2pggGBtpUaotYU3tEDZsS6s?e=5xVCwZ
Shell7
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