How Can I Automatically Calculate Employee Late Times in Excel Attendance Sheets?

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.

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

Can anybody tell me what kind of Excel knowledge is required in an HR generalist profile?

Please help me out asap, because all the time the requirement is for Excel knowledge... :sad: