Late And Early Time Calculation And Excel Formule - XLS Download - CiteHR
Hr Personnel Manager
Admin Manager
Admin Manager

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hello Users... please find herewith attached file.. Thanks

Attached Files
Membership is required for download. Create An Account First
File Type: xls Excel-Formulae (1).xls (1.13 MB, 6164 views)
File Type: xls In-Out Log (EXCEL FORMULA OF LATE &EARLY).xls (20.5 KB, 4719 views)
File Type: xls MS Excel Formulas (1).xls (2.40 MB, 3769 views)

Formulae Xls is wonderful. This is really help ful.
I am having one query. I have an attendance sheet . Where I have marked Weekly off of a month as W.and if a employee is on leave I mark it as L. Using countif i take the number of weekly off and leave. Now my question. If there is an L before and After W. i.e. "L" , "W" and "L" i want the count of L to be Three and it should not take consider W in Countif.of W.

Dear sir,
i'm working currently working at dombivli with dns bank as a assistant manager.
My english communication is a little bit weak.
So, it's my request to you to please suggest me a proper solution to said problem.

Sir,its really worked out,thanks for this useful post
we have more than 45 nos of employee and we need to calculate which employees are coming late every day and in a month how many days coming late. after calculating late coming days in a month to deduction salary for the same.
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.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™