Hi, I am new to excel and my job apparently requires a lot of tracking to be done with excel.
Currently, no system in place to do any of the work and I realise I am doing things repeatedly.
Read somewhere that i can automate the process in excel but not sure how I can do that.
Below are my problems.
1) I have to book slots for certain use of items in our excel. Some items have only 5 slots available throughout the year, other items have 32 slots, others have 8 slots. I created different sheets for each slot. I intend to have a calender in each sheet to show the slots available. The calender is not just for one year but to run continuously to the following years. Something like a hotel reservation slot? And a table would be below it, where i will list the name of the client, the order number, the start date and end date of the banner. All i have to do is to key in the details in the table, and the slots in the calender would automatically be highlighted to show that that particular slot has already been booked? Can this be done?
2) I also have to track the first login time of all the employees in the company. As we are using the fingerprinting system, there will be multiple fingerprint times in the excel sheet. So far i am doing this manually till i am cross eyed. The first column is The fingerprint time in YYYY-MM-DD HH:MM:SS. The second column is the team the employee is under and the third column is the employee's name. If the employee's first login time is after 9:16 AM, the employee would be marked as late and I would like that to be highlighted as well. Tried using conditional formatting but that doesnt seem to work. Can that be done?
Bookmarks