[email protected]
Hr Personnel Manager
Raghavendravijayrao
Admin Manager
Namrata
Admin Manager

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hello Users... please find herewith attached file.. Thanks
From India, Chandigarh

Attached Files
File Type: xls Excel-Formulae (1).xls (1.13 MB, 6326 views)
File Type: xls In-Out Log (EXCEL FORMULA OF LATE &EARLY).xls (20.5 KB, 4894 views)
File Type: xls MS Excel Formulas (1).xls (2.40 MB, 3912 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.

From India, Thane
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.

From India, Badlapur
Sir,its really worked out,thanks for this useful post
From India, New Delhi
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.
From India, Ahmedabad
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™