Idea needed - Employees Days and hours out of work

[zico8]

Hi,
I prepare excel tool for measure employees production efectivenees.
Briefly, it measures production done and available work time for each employee.

It works preety good but the issue is how to collect workers absence.

I have about 80 people and looking for any way how could I easy add whole day off (or days), as well as some hours off during work day. It should be easy to do for one person, a few or all of them.

Do you have any idea? Maybe you have seen something like this?

I imagine the best way how to manage that with an userform with all worker's names with checkboxes and one checkbox 'select all' and one 'deselect all' with calendar fields date and time for begin as well as for end (with possibility to choose 'all day' - then hours fields will change to disabled. Similar like google calendar event).

Have you got any idea how to simply manage it?

Thank you in advance. I will appreciate your help.

 

[Fazza]

Dzien dobry, Zico

It would help to understand a little about how the data is set up. Such as if you can post a sample.

I'm guessing the data is stored in a simple table.
My initial thoughts are to have a worksheet event code - like a RIGHT click - that starts some VBA, seeks user input, and modifies the data.
So, you'd pick the range of cells you wanted to change, then RIGHT click, then input the change details, and the code would make the changes.

regards, Fazza