Attendance tracker IF functions
Hello
I badly needed help in doing my template.
I was trying to create an attendance tracker where i can identify whether a person is "early", "on time" or "early" to be shown the in Status Column.
I tried using some formula but it doesn't seem to be right.
time.png
I have attached the link to file below
https://drive.google.com/open?id=1HV...HwYpvkUz3GsN7U
Last edited by xygrax; 04-03-2018 at 03:50 AM.
Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!
- Use concise, accurate thread titles.
- Your post title should describe your problem, not your anticipated solution.
- Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
- Responding to a request to change your thread title by doing so is mandatory.
To change a title go to your first post, click EDIT then Go Advanced and change your title.
No help to be offered, please, until the OP complies with this request.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Sorry - you still haven't explained the problem. Instead, you have told us what you think the solution should be. Try again, please. Something like this:
Formula to identify whether a person is "early", "on time" or "late"
sorry for the confusion.Originally Posted by AliGW
below is what i am trying to do. i want to display whether the person is late, on time or early in "Column P".
In Column N, it shows the schedule and in Column M shows their Time In.
Whenever i use this formula, =IF(M5>N5,"Late",IF(M5=N5,"On Time","Early")), it's displaying all lates and in accurate.
time.png
After take a look on your sample data sheet, found that there are some error on your date in Column M.
If use your date in your file, will return results something similar to you, but if i type in the new date, i can reflect the correct return.
Daily Logs 2.png
Change the formula
M2Formula:
Please Login or Register to view this content.
Now use
P2Formula:Please Login or Register to view this content.
You will need to round each cell as these cells produce time and time can be long after decimal
Last edited by shukla.ankur281190; 04-03-2018 at 05:24 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
i tried to copy and paste the formula =IF(M2="","",_xlfn.IFS(N2<M2, "Early",M2=N2,"On time",N2>M2, "Late")) but it's giving me #NAME?
I'm using 2013 version.
time.png
Did you check post #6
Re: Attendance tracker IF functions
Change the formula
M2Formula:Please Login or Register to view this content.
Now use
P2Formula:Please Login or Register to view this content.
You will need to round each cell as these cells produce time and time can be long after decimal
Hey!!!! Thank you so much!!!! It works! I really appreciate it.
I love you all!
Happy to help you and thanks for feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks. Also you appreciate by clicking start * icon left corner on your thread screen on those post which helps you
Nobody should have responded to this thread!!!
Your posts did not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction then send a private message to them asking for clarification.
All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks