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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt