Forum Discussion
Excel Help
Hello! I am trying to streamline my scheduling and timesheets through Excel, however I am unsure on if what I am trying to achieve is actually achievable... Firstly, I've got a table with cel...
It would help if you attached a copy of the workbook.
HansVogelaar Hello, sorry I've attached it here... I wasn't sure what was best to do...
See the attached version (now a macro-enabled workbook, so you'll have to allow macros when you open it).
To view the code, right-click the sheet tab of the Rota sheet and select View Code from the context menu.
Can you explain how hours should be calculated?
HansVogelaar ahh Macros! Makes sense now! Thank you!
Hours is still the bit I am trying to figure out... What I want to do is if for example someone is rotared in for a stage shift then their hours are 5.5hours and it automatically inserts that into the time sheet
