Collaborate on Taxi Bill Format in Excel for Human Resources with Ease Using airSlate SignNow

Taxi bill format in excel for Human Resources

Chris Minard here let me show you some Excel functions if you're a HR professional you should know but also if you just want to master Excel here's some great functions I'm gonna start off in h1 with equals Tod a why the today function will always return today's date it's reading the clock in your computer so tomorrow it'll say November 1st you can also add and subtract days on the today function so there's November 1st automatically I did one also I would like to know how many years of service our employees have worked a couple different ways to do this I could take the current date - the date of hire there's 884 days and then I could simply take that and divide by 365 days in a year and it gives me two point four two years but what I really want to do is just see two years then I want to know how many months because I don't want to figure out what point four two is is months and then how many days so there's an Excel function if you go to formulas and hit insert function make it look make it show all and go down to the letter D there is a function called dated if now you'll never see it in your Excel functions dat EDI F is not in there cancel the dated if function is a function that was created to pull in Lotus 1-2-3 workbooks into Excel or convert them so you have to manually type this function out and I'm going to take the date of hire comma the current date comma I'm looking for the number of years I'm gonna do the letter Y in quotations it's not case-sensitive there's my two years let's test this real quick I'm gonna make this 615 2014 there are three years I'm now going to come back into this function I'm gonna make the date of hire a mix reference I'm going to make today's date an absolute reference that away I can pull this over and this time instead of looking for the number of years i'ma look for the number of months forty months if you're gonna test this here we go that date - that date make it comma style one thousand two hundred thirty five days and 30 days in a month notice that's my point you don't want to take 30 days in a month because 30 times 12 is 360 so that 41 is wrong that's why dated if month is better but I only want to see the number of months since the three years so I'm gonna do Y M for months and then for the number of days there's the letter D oops my bad and we fix that there's the letter D there's that one thousand two thirty five I'm gonna do MD so this employee if today is November first in their data higher is in cell g4 they've worked three years four months and 17 days let's test it I'm gonna have him starting on eleven one 2016 I hope I get one year perfect make it 11 - 2016 there you go it's working highlight all three autofill down you know how to autofill I'm not going to do that another function that I really like is I don't know how many working days or in the year 2017 over in column e I've listed all the company holidays for 2017 I'm going to do equal symbol net there are two Network days functions this one the top one has always been around it'll work in this example but I actually prefer this do when they have start date , end date , here's what I prefer this one when you get to weekend it actually lists all these weekend options they were smart enough to make the number one Saturday and Sunday because that is most companies have Saturday and Sunday off comma what are your holidays e5 through II it is ok to include blanks thirteen is correct but I'm going to go ahead and stop it in case I don't have all the holidays in I'm gonna stop it at 17 so I can add more holidays there are two hundred and fifty-one workdays for the year 2017 for this organization you can also use it to figure out let's go make this absolute reference f4 f4 you can also use this to figure out how many workdays are there in the first quarter sixty-three there's January through March and let's go look for the last quarter should be less days because we have those Thanksgiving and Christmas and there is this would also be handy if you told somebody I'm gonna give you twelve days to finish a project they're an hourly employee but the issue is I said twelve days well you you assuming they have twelve days but you gotta figure in the weekends you've got to figure in these days off and we also forgot to put in January 1 2018 they really have six days to do it so there's Network days opposite of networking days and when I met with I had a training class and I had some HR professionals in it they told me that they have employees retire and they have earned they have accrued vacation time they have accrued PTO to time off I'm going to give bill Davis he's the employee he wants to retire Bill Davis wants to retire on January 2nd 2018 here our company holidays and I even threw in June 1 2018 which is a Monday his bill gets paid for that day he's a full-time employee our policy is if bill wants to he can use those 22 days and leave the company prior to January 2nd so the question is what day would his last workday be and I thought it was a great question and I knew it had to do with how many working days are left but it's not Network days it is work day dot int L so this is something new I learned I figured it out so double-click it what's tricky about this a start date is actually his retirement date comma how many accrued PTO days do we owe bill for you can't put in cell d5 it has to be negative d5 comma bill works Monday through Friday comma here are all the holidays and even if they've happened in the past because I'm assuming that today is November 1st up in g2 so even if they've happened in the past it's okay to select them all and when I press ENTER I got November 28th will be Bill's last day of work after that we'll never see him again he's retiring if you want to test this here's how I would test it since Bill wants to retire on January 2nd 2018 and right now he has 22 vacation days let's give him 0 because I should get January 2nd 2018 which is a Tuesday and I do let's give him one day of vacation 12 29 so 12 29 is a Friday he works he works on Friday when he's done with the day Saturday he's off Sunday he's already off with pay Monday's the holiday he gets paid and then as one vacation day kicks in for the second so 12 29 would be his last day one more let's just make it 12 days shut shows 12:12 let's see if that's right I'm gonna just I'm gonna manually count these there's three days for that week plus five is eight days plus three is 11 and Tuesday would be the twelfth Tuesday January 2nd there you go so it is working there's that formula work day dot int L I don't like really long videos and I've already gone over nine minutes so what I'm going to do is there's four more functions that I want to cover for HR professionals so I'm going to make a second video and go ahead and stop this one but thank you for your time