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
From India, Hyderabad
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
From India, Hyderabad
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
From India, Bangalore
1From 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
From Oman, Muscat
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
From Oman, Muscat
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
MS-EXCEL - INTRODUCTION TO PIVOT TABLES.pdf
The wonders of Ms excel.zip