Collaborate on Bill Format in Excel PDF for HR with Ease Using airSlate SignNow

Bill format in excel pdf for HR

hi there folks and welcome back to another tip for Microsoft Excel today we're going to be looking at a different option for you to build your own time sheet so a time sheet would be used to help the hours worked or to keep track of maybe a contractor or a contract position or something informal you you wouldn't use this for like an entire organization well you could use a time sheet but we would build a little B differently this is going to be for managing the time of an individual so let's get started here the first thing we want to do is create a row that we can always see we don't want anything disappearing so to do that we're going to just freeze the cell make it stand out a little bit give it some information and so we're going to say date worked we're going to say time in and we're going to say time out not the kind of timeout where you got to sit in the corner just a time when you get off work and you go and rest and so our next one is going to be total hours worked and and we're going to create one more and we're going to say gross pay even though it's not gross to ever get paid um the gross pay is simply the total amount we're going to need a few pieces of data here and so we're going to just create a box over here that says hourly rate and we'll keep with the beautiful format here and we're going to make that one yellow also just put a nice little border on it and then we're going to format this in a dollar and we'll say that the hourly rate is $35 okay and let's say that Just for kicks you want a additional information column just so you know what it is the person's working on so we're going to open that up a little bit and we'll format it by wrapping the text so that they can put in as much information as they need and it won't get all crazy so now we got everything formatted and we're going to go ahead and put a border here real quick and then we're going to also format this and we'll just click on the entire column a right click go to format cells and we're going to come right over here to date and let's say we use this one here we want the day the month the date and the year and so let's say that we were creating a Time log for May 4th 2017 and of course we want to format these two and so we highlight both of them and we're going to come over here to time we're just going to give it a basic 13pm type format and so what that's going to do is let's say we clock in at 7 a.m. and we get off on this day at 5 p.m. well that's going to give us our time format in this entire column and this is formatted for date so this entire column is going to populate just like this in fact if we drag down we go to the fifth and let's say we drag down we go to the sixth okay so hopefully we're not working on Saturdays like this shows here but you'll see that the formatting makes it a lot cleaner and simpler to do so now to calculate the hours worked we need to add a formula in Excel so that it automatically populates based on the time in and time out and to do that what we do is we put in our equal sign and we're going to do an open bracket and we are going to always select the time out first and then and then we'll subtract that from the time in now we're going to close that and we'll hit enter and oh shows up 10: a.m. why does it do that well it's because we didn't format this so what we want to do is grab the entire column you see in the background of time is actually a number in Excel and we're we're about to see that here in just a second the way we format is we rightclick again we go to format cells and we're just going to put a general formatting on there now we see that we get a 4167 which as you can tell is not the hours worked so why does Excel do that well Excel does that because when we work with times here this is calculating based on a 24hour time period the way we correct that that is we come up here and we simply multiply by 24 and we'll close that off and we see that we work 10 hours on this day now what we want to do even more specifically is we want to copy this formula that we just built then we want to come up here and select column D now we want to rightclick and you'll see that there's a quite a few different paste options here so the one that we're actually going to look for is not the values we don't want that what we want is the formulas that are right here you also have an option for formatting uh for links but what we what we want to paste in there is the formula in the entire column so we're going to select on that you see Excel is going to do its thing and now if we come over here on Friday May 5th 20 17 let's say we're working really hard this day and we came in at 6:30 a.m. and we got off at let's say 6 p.m. we'll now see that we put in 11 and 1 12 hours of work on this day and Excel will automatically calculate that all the way down in this column so we obious L don't want this to have the formula in it the way we take care of that is we're just simply going to delete it out of this one box and we're going to say total hours worked and let's go ahead and keep this nice and pretty also and in the center so we got our total hours work next thing we need to do is calculate our gross pay this is how much money we're going to make for each individual day now the way that we'll do that is we're first going to format this in money and then we'll give this another unique shade just so that people know it's automated and they don't need to touch it and we're going to hit our equal sign okay and first things first we're going to select cell H 4 and we're going going to multiply that by hitting the Star Sign by the total hours worked which was D4 now we want to make sure that we lock this hourly rate so that when we copy it down it doesn't um it doesn't change the number it's going to always stay with that $35 or whatever is in the hourly rate box the way we lock it again is by hitting F4 and then we're just going to hit enter and we'll see that on this day we made $350 so we're just going to copy that and we're going to select column e like we did with column D and we're going to rightclick and we're going to go ahead and paste in the formula you'll see excel's doing its whole thing and it's going to take a little bit of time because it's sending it down to every one of the cells and when we get done here when we get all done we're just going to change this top one and it'll say uh gross pay and so now we can see that as we put in our times let's say 8:00 p.m. because it's Saturday here or 8:00 a.m. excuse me um to 10 a.m. we put in 2 hours we made 70 bucks there now we'd also like a column that tells us how much is due to us we want to know how much we've got to pay and so total pay sorry let's call that gross pay let's use official uh accounting terms here and we're going to highlight that yellow just give ourselves a little box there and now we've got our hourly rate which is $35 an hour and we've got our gross pay which is going to be the sum of all each day and so to do that we hit sum Open Bracket and we're just going to select this entire column then we're going to close it out and we see that we have 82250 now let's say we come come back in on uh well let's say the 8th we worked pretty hard and so took a couple days off so it's Monday Monday the 8th now and we're ready to go at it again we came in at 700 a.m. and we got off at 5 p.m. just a normal normal day at work now you'll see that your gross pay over here automatically populates based on your total for the day and of course if you want any additional information you can just place it right in there and each time you come in you just put the hours you worked in and it'll automatically populate the information you needed okay and that's the time sheet in Excel a pretty simple way to manage um contracts or or one person's hours worked and the gross pay that you owe to them hopefully this solution will help you today we learned about how to calculate the total hours worked and how to calculate the gross pay in Microsoft Excel subscribe to the station down below and we'll keep giving you tips for Microsoft Word PowerPoint and Excel and remember if you have any questions below or you're looking for a solution in any of those three applications from Microsoft go ahead and post your questions down below and we'll get back to you as soon as possible thanks for watching and have a wonderful day