I want to put a formula in excel attendance sheet to calculate late time of employees if they r late than official time, for example
my office time start at 8:00Am I want to calculate the late timings of employees if they r reaching 10 minutes late or 1 hour then in 1 column.
it would come automatically.
plz help to put formula for this..
Many thanks
17th June 2007 From Pakistan, Karachi

Zainab Ali
Hr Admin Assistant
Hr Consultancy Firm
+1 Other

In excel sheet, make four columns as under:
a) 1st column : Date : 1st Jun, 2nd Jun .....
b) 2nd column : starting time, say 8:00 (write in this format only)
c) 3rd column : Entry time of employees, say 10:10 (write in this format only)
d) 4th column : Late by ___ minutes (comes automatically by applying the formula : (c3-b3) * 1440
If you want any more clarification, do get back to me on
18th June 2007 From India, Ahmadabad
Can anybody can tell me that what kind of excel knowledge is required in HR generalist profile..:icon9:
23rd December 2008 From India, Delhi
Please help me out asap,because all the time the requirement is for EXCEL KNOWLEDGE...:sad:
23rd December 2008 From India, Delhi
Please login to participate in this discussion. Discuss problems, ideas, solutions with industry peers. Stay up-to-date with what's new and what's happening in the industry. Create Account (No Registration Charges)

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network