Zainab Ali Started The Discussion:
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
Posted 17th June 2007 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
Posted 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
Posted 18th June 2007
Attached FilesProvided by community member gmamatha82. Register to join your network of peers.
File Type: xls attendance_formula_sheet_127.xls (106.0 KB, 15336 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?
Posted 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
Posted 12th August 2008
Hiii It’s nice,can overtime also calculate in this sheet.??? pls tell me Regards, jagjeet_sford@rediffmail.com
Posted 27th August 2008 From India, Vijayawada
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
Posted 14th October 2009 From India, Bangalore
Time, Late Mark, VL,SL,C-OFF all Calculation in one file. For Any Changes mail me on amitkhot11@gmail.com Regards Amit Khot
Posted 14th December 2010 From India
Attached FilesProvided by community member amitkhot11. Register to join your network of peers.
File Type: xls Attendance.xls (619.5 KB, 5233 views)
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

Posted 14th December 2010 From India
Attached FilesProvided by community member amitkhot11. Register to join your network of peers.
File Type: xls Attendance.xls (619.5 KB, 1655 views)
Hey Zainab,
This is quite tough to count late hours daily.You have to consider the late timings on the last day of the month and deduct the salary of employees accordingly.It will become easy if you'll use an attendance software or a bio-metric machine.
Posted 24th December 2013 From India, Jaipur



 
 
 
 







Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network