Get Your Invoice for Hours Worked Template Free for Personnel

Invoice for hours worked template free for Personnel

Hi! In this tutorial we’ll go over a way to track hours worked in Excel. We’ll also go over how to calculate pay in Excel for the hours worked. So, we'll start by labeling the headers that we'll need. We'll need headings for Date, Start Time, End Time, Breaks, Total Hours, Pay Rate and Total Pay. Ok. So, now that we have our Headings, let's bold them and make sure that we can read them all. Now, the Date field, that's just going to be the day that you worked. So, I'm going to do just a couple of days, because we're just going to illustrate how this works. So, we'll do 1-8 and 1-9-2018. Now, the Start Time and End Time is just when you started working and when you finished working. So, I'm highlighting those cells, right clicking, and, under Format Cells, I want to format them as Time. Now, I find it easier to read Start and End Times with a PM / AM designation at the end. So, these are great for that or ones with military time - which is the ones that start with the 13 in front of them. So, I'm going choose this one. If you need to go to the seconds, these, with the 3 numbers - that's what that means. So, I'm going to click OK. And we'll say we started at 8:00 AM on the 8th. And I'm going to type AM at the end of it. And then on the 9th we started at 9:00 AM. And, for the End Time, we'll say we finished at 5:00 PM and then we'll do 4:00 PM on the next day. So, in the Breaks column, I log for my clients the amount of time that I was on breaks. If you need to do a Start and End Time, then just simply copy these over and you could do a Start Time for your breaks and End Time for your breaks. But I'm just going to log the total time that I was on breaks. So, we'll right click, Format Cells and, under Time, I'm just going to choose one of the formats that doesn't have a PM designation next to it. So I'm just going to click on this 13:30. And, we'll say on the 8th, we'll say that I took a 30 minute break. And we'll do 1 hour on the 9th. So then, to calculate the Total Hours, we'll just type = ( and your End Time - your Start Time - the amount of time you took for Breaks. Close your parentheses and then multiply that by 24. And then we'll just copy this for the next day. So, a couple of things in the Total Hours. First, make sure that it's formatted either General or as a Number. Ideally with 1 to 2 decimal points. So, if you have like here, 8 1/2 hours, you can see the 0.5. And then, also, just FYI, the reason you multiply by 24 is just to normalize it back to a regular number. Because if we were to multiply it by 1, you see that all it did was calculate that 8 1/2 hours is 35% of a 24 hour day. So we need to multiply our total hours by 24. So now that we have our hours, the next thing we need to do is plug in our Pay Rate. So, just an arbitrary number, we'll say $30.00. And we'll make this a currency. And then the Total Pay will just be your Total Hours x the Pay Rate. So, hope you found this tutorial helpful to learn how to track hours worked using Excel and how to calculate pay in Excel. If you enjoyed it, please make sure to Like the video and don’t forget to subscribe to this channel. Thanks!