I want to put a formula in Excel attendance sheet to calculate the late time of employees if they are late than the official time. For example, my office time starts at 8:00 AM. I want to calculate the late timings of employees if they are reaching 10 minutes late or 1 hour late in one column. It should come automatically. Please help me put a formula for this.
Many thanks.
From Pakistan, Karachi
Acknowledge(0)
Amend(0)
12Many thanks.
From Pakistan, Karachi
Acknowledge(0)Amend(0)
In Excel sheet, create four columns as follows:
a) 1st column: Date - 1st Jun, 2nd Jun ...
b) 2nd column: Starting time - e.g., 8:00 (write in this format only)
c) 3rd column: Entry time of employees - e.g., 10:10 (write in this format only)
d) 4th column: Late by ___ minutes (calculated automatically by applying the formula: (c3-b3) * 1440
If you need further clarification, feel free to contact me at cp@dcspl.com.
Regards,
Chetan
From India, Ahmadabad
Acknowledge(0)Amend(0)
a) 1st column: Date - 1st Jun, 2nd Jun ...
b) 2nd column: Starting time - e.g., 8:00 (write in this format only)
c) 3rd column: Entry time of employees - e.g., 10:10 (write in this format only)
d) 4th column: Late by ___ minutes (calculated automatically by applying the formula: (c3-b3) * 1440
If you need further clarification, feel free to contact me at cp@dcspl.com.
Regards,
Chetan
From India, Ahmadabad
Acknowledge(0)Amend(0)
Can anybody can tell me that what kind of excel knowledge is required in HR generalist profile..:icon9:
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Excel Formulas.xls
Excel Formulas.ppt