QUERY
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

17th June 2007 From Pakistan, Karachi

PARTICIPATING IN DISCUSSION:
Gmamatha82
Hr Executive
Zainab Ali
Mahaveer
Employee
+3 Others

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
18th June 2007 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
18th June 2007

Attached Files
 attendance_formula_sheet_127.xls (106.0 KB, 17408 views)
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?
30th May 2008 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
12th August 2008
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
14th October 2009 From India, Bangalore
U can use this attendance sheet just entern in and out time or VL,SL,C-OFF,CL,Holiday, you will get the output
For any qurie or modification mail me on
Regards
Amit Khot

14th December 2010 From India

Attached Files
 Attendance.xls (619.5 KB, 2805 views)