Vlookup Solution in Excel Using a List
Answer to a question of one of our website visitors:
I am creating an attendance sheet in excel 2007, i need your help in creating the time slots.
eg- work starts at 10:00am, if someone comes between 10:15 – 10:30 then its should be categorized as late, if he come between 10:30 am – 11:30 then it should be categorized as permission, if he comes between 11:30 – 3:00pm then its a half day and if he comes after 3:00 its full day off.
Please send me your e-mail address and i will send you the sheet which i am working on.”