openshift.xlsxthank you so much tigeravatar.. the code helps.. can you please help me also with this excel file i attached.. because the schedule of the employees on that excel file are open shift.. they don't have fixed schedule.. and I need their log in and log out be plotted on the table also. every employee still has his/her worksheet. If the employee's log in is from 4:00 am to 12 pm then it should go to the morning log in.. if the log in is from 12:01 pm to 6 pm, it will go to the afternoon log in.. if the log-in is from 6 pm to 3:59 am it will go to the evening log-in.. For the log-out, if the employee log out 4:00 am to 12 pm, it will go to morning log-out.. If the employee log-out from 12:01 pm to 6 pm, it will go to afternoon log-out and if the employee log-out from 6:01 pm to 3:59 am it will go to the evening log-out.. then the att_time column on the mainworksheet will be plotted also on the Time Worked column on the template..thanks again