Hi everyone,
I use a spreadsheet to check my staff's time cards. I use a grid with dates in the top row and the time by 30 minute increments in the first column(actually second column (B) but it is the first column with any data). I fill in names of the staff across the grid to represent the hours they have claimed on their time sheets. This way i can easily see if 2 people have double claimed hours or if hours haven't been claimed at all.
I use the following code(which i got from this forum @ http://www.excelforum.com/excel-prog...-formulas.html) to find the start and end times for each person and sort them into easy to read tables. Unfortunately I don't really understand this code. What I actually would like is code that would do the opposite of this.
I would like to use a user-form to have my management staff enter in the time in a traditional manner (Pick staff name, Pick start date and time and end date and time from combo boxes) and have it fill in the grid accordingly. The code would need to alert the user when hours have been double claimed and also if at the end of entering all the time cards if hours have been unclaimed. I hope my request is intelligable, i'm pretty sure it's possible but haven't got a clue where to start. Thanks in advance for the help guys
Bookmarks