Hi,

I went through the excel sheet. Thanks for your help. And i would like to know how are you calculating the total hours for a single Employee. i have highlighted the total hours calculated manually in next sheets(*sheet 3 n 1)
emp1 data.xls


000000003 Hafsah 08/11/2013 November 8:32 Chk in morning
000000003 Hafsah 08/11/2013 November 12:07 Out for Lunch
000000003 Hafsah 08/11/2013 November 14:58 In after Lunch
000000003 Hafsah 08/11/2013 November 17:55 Ckh Out Total Hours
16:15
000000003 Hafsah 09/11/2013 November 8:32 Chk in morning
000000003 Hafsah 09/11/2013 November 13:07 Out for Lunch
000000003 Hafsah 09/11/2013 November 14:05 In after Lunch
000000003 Hafsah 09/11/2013 November 18:09 Ckh Out

Regards,