Late Time Calculate In Excel - Payroll Software
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Talk To Seniors

Late Time Calculate In Excel - Payroll Software

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

Anjuman Ara Baby - Member Since: Aug 2005
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

gmamatha82 - Member Since: Dec 2006
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


Attached FilesProvided by community member gmamatha82. Join us to learn and grow with your peers.
File Type: xls attendance_formula_sheet_127.xls (106.0 KB, 6524 views)
kingcitehr - Member Since: May 2008
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?

mahaveer - Member Since: Feb 2008
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

msjagjeet - Member Since: Aug 2008
Hiii It’s nice,can overtime also calculate in this sheet.??? pls tell me Regards, jagjeet_sford@rediffmail.com

biijuu - Member Since: Dec 2008
Download a free software to monitor employee late in, early out, work time, overtime, and much more.

Payroll Software, Attendance Software, HRM Software, Indian Payroll Software



Payroll Software, Attendance Software, HRM Software, Indian Payroll Software

rupsihr - Member Since: Jul 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

deepa4pillai - Member Since: Dec 2009
Hi, Pls help to download this software. I tried using it but in vain. kindly guide for the same. Thanks, Deepa

amitkhot11 - Member Since: Jul 2008
Time, Late Mark, VL,SL,C-OFF all Calculation in one file. For Any Changes mail me on amitkhot11@gmail.com Regards Amit Khot


Attached FilesProvided by community member amitkhot11. Join us to learn and grow with your peers.
File Type: xls Attendance.xls (619.5 KB, 1366 views)


Found This Useful? +Vote Up This Page 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.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


6
LIKES

10579
VIEWS

12
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network