Late time calculate in excel - payroll software Xls Download
CiteHR
 
HOME ANSWERED 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 - Contributing Member
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 - Contributing Member
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, 5753 views)
kingcitehr - 
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 - 
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 - 
Hiii It’s nice,can overtime also calculate in this sheet.??? pls tell me Regards, jagjeet_sford@rediffmail.com

biijuu - Contributing Member
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 - 
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

Hi, Pls help to download this software. I tried using it but in vain. kindly guide for the same. Thanks, Deepa

amitkhot11 - 
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, 1080 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.
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.


Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


6
LIKES

10191
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