Zainab Ali
12

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

From Pakistan, Karachi
dcp149
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
Rgds,
Chetan

From India, Ahmadabad
sanjuktaganguly
Can anybody can tell me that what kind of excel knowledge is required in HR generalist profile..:icon9:
From India, Delhi
sanjuktaganguly
Please help me out asap,because all the time the requirement is for EXCEL KNOWLEDGE...:sad:
From India, Delhi
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.