Ms Excel - Xls Download - Excel Formula

Hi Shariff,
Looking at the attachment that you uploaded it looks like you are using a complicated format. Sticking to your basic question i.e calculating Early Login and Late log out, please find the attachment that i prepared, which might help you to know on each employee prespective which day he was early/late.
Also as indicated by Santosh it depends on the time entered in the log out cell that it calculates the difference time. so to ease out this, inserted a formulae (Column F) where if the log out time is less that login time it gives error.
Please let me know if you need more details
Rgds
Chakra

hi,,
Thank you very much for ur concern Boss,,,, what u have sent the excel sheet ,, thats the one i was looking for,,,, thanks you very much ,,,
Regards
Shariff

Dear sir
plz tell me this excel set plz help me
16 10:09 14:00 3:51 17:27 22:34 5:07 8:58 9:00 -0:02
17 0:00 0:00 0:00 0:00
18 9:25 14:00 4:35 16:34 23:30 6:56 11:31 9:00 2:31
19 8:40 12:30 3:50 16:33 22:03 5:30 9:20 9:00 0:20
20 8:33 11:29 2:56 16:38 22:32 5:54 8:50 9:00 -0:10
21 9:56 14:00 4:04 17:30 22:38 5:08 9:12 9:00 0:12
22 8:34 12:31 3:57 16:41 22:11 5:30 9:27 9:00 0:27