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
17th November 2011 From India, Hyderabad

Attached Files (Download Requires Membership)

Book1.xls (37.5 KB, 160 views)

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
29th December 2011 From India, Bangalore

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
27th February 2012 From Oman, Muscat