I want to put a formula in excel attendance sheet to calculate late timings 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 ETC.
plz help to put formula for this..
Many thanks
From Pakistan, Karachi
12my 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 ETC.
plz help to put formula for this..
Many thanks
From Pakistan, Karachi
It is very simple. Formula is =start time - real time. Make 3 columns, in first column start time, in 2nd column real time and put the formula in 3rd column is = 1st column-2nd column. Thats it. anju
From Germany, Aachen
From Germany, Aachen
Hi Zainab,
Please do find the Attandance formula Sheet Which I had created.. You can modify it as per your needs... Hope it might be of some use to you.
Please note: Timings need to be Entered in a Twenty four hour format
Regards,
Mamatha
Please do find the Attandance formula Sheet Which I had created.. You can modify it as per your needs... Hope it might be of some use to you.
Please note: Timings need to be Entered in a Twenty four hour format
Regards,
Mamatha
I want to make time attendance sheet that able to calculate late time of employee.. Ex. I start work at 8.30 if someone come at 8.45 .It should display15 min late .. but I do use = B2(real time) -8.30 (start time ) and it turn out a minus (-8.30 ) when my sheet is empty .. How I can do?
From Thailand, Bangkok
From Thailand, Bangkok
We are deducting salary later commers I am working with pharmaceutical distributor and here leve facility also not there, if ond day without information we are deducting double salary it is correct or any other alternative is there please let me inform
CAN ANYONE PLEASE GIVE A FORMAT OF ATTENDANCE WHICH CAN CALCULATE 3 DAYS OF LATE INTO ONE ABSENT ITSELF ALONG WITH FORMULA FOR PL AND CL WHICH ARE PAID AND COUNTED AS PRESENT ON MY ID 
From India, Bangalore
From India, Bangalore
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.
Time-management -7439-4556_187. ppt
Time-management _sent__1__200.d oc