VLOOKUP SOLUTION USING LIST IN MS EXCEL

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
Home

Answer to a question of one of our website visitors:
"Hi,
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 halfday 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."


Reference
Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010