Collaborate on Self Employed Invoice Template for Hours Worked for Building Services with Ease Using airSlate SignNow

Self employed invoice template for hours worked for Building services

hello hello in this video you're going to learn how to build this simple but extremely useful time sheet in Google Sheets you can enter start times and stop times and the template calculates the total hours automatically you can also track work time over several weeks as well and you can view all the hours for each week on the summary page plus I will show you how to easily add more weeks in just a matter of seconds oky doie now that you know what your build building let's get to it as always you will be starting with a blank Google Sheets spreadsheet the first thing that you want to do is get rid of all the rows and columns that you don't need so start by selecting columns G through Z right click and delete next click right here in the name box and type in 10 colon 1000 and press enter this will select rows 10 through 1,000 and once you have them selected just right click and delete now let's make these cells a little bigger so select rows 1 through 9 right click and resize rows change the height to 30 and click okay awesome next click here to select every cell then then change the horizontal alignment to Center and change the vertical alignment to Middle now let's type in some data start by selecting cell A1 and enter date then in B1 type in in then out in out and hours then select cell A9 and type in total now we need to adjust the number formatting for the various columns so start by selecting column A then click the more formats button here and select custom date and time from here pick a date format that you like or you can build your own date format up here and once you've got it click on apply next select columns B through e Click the more format button and select custom date and time pick a time format that works for you and then click on apply finally select column F click the more formats button here and select the format number fantastic now it's time to add in some dates so start by selecting cell A2 and enter a date of your choice I myself will be entering entering in June 3rd 2024 since it's a Monday then once you've entered the date select cell A3 and enter the following formula equal A2 + 1 you can then drag this formula down with the fill handle all this formula does is increment the date in the cell above by one thereby giving you the dates in order okay now for the times go ahead and enter in some sample times like so once you've added the times select cell F2 and enter the following formula equals open parentheses open parentheses C2 minus B2 close parentheses Plus open parentheses E2 minus d 2 close parentheses close parentheses time 24 this formula calculates the difference between each set of times and then it adds those together and then of course it multiplies all of that by 24 now you multiply by 24 here to give you the numerical number of hours and it works this way because times are simply stored as numbers in Google Sheets in fact times are stored as fractions of 24 since there are 24 hours in one day for example 6: a.m. is equivalent to 0.25 because 6 hours / 24 is equal to 0.25 and so we multiply by 24 here to transform the fraction or time into a numerical number of hours that being said once you have the formula working go go ahead and use the fill handle to copy the formula down to cell f8 finally select cell F9 and enter the formula equals sum function F2 through f8 close parentheses and press enter this gives you the total number of hours for the week awesome now that the formulas are complete let's add in some formatting starting by selecting row one go ahead and bold the font and add a light green fill color or a color of your choice next select row 9 bold the font and add a light blue fill color or a color of your choice then select A2 through A8 and add a light gray fill color then select F2 through f8 add a light gray fill color and change the font color to Blue now for your final step double click on the sheet tab at the bottom and change the name to wk1 and now you have your weekly time sheet fantastic up next we're going to build the summary sheet and I'll also show you how to add more weeks as well first the summary sheet go ahead and right click on the sheet Tab and select duplicate move the copy to the front and rename the copy to summary then on the summary worksheet select columns B through e rightclick and delete you can then delete all of the data in A2 through B8 at this point select column a click the more formats button and select automatic then change the value in cell A1 to we now this next part is very important enter the name of the week one worksheet tab into cell A2 and you want to be sure that what you type here matches the worksheet name exactly otherwise the formula that you're about to write isn't going to work and once you've written the worksheet name which in this case is wk1 go ahead and select cell B2 and type in the following formula equals indirect function A2 Ampersand quote exclamation point F9 quote close parentheses this formula takes the worksheet name in A2 and uses it to create a reference to cell F9 on that worksheet and this is why it's important to make sure that the text in cell A2 matches the worksheet name exactly and now that you have the formula written all that's left is for me to show you how to add more weeks to your spreadsheet to add another week follow these exact steps rightclick on the week Tab and select duplicate rename the copy to wk2 or anything that you want clear all of the time data but make sure that you don't delete the formulas and then then change the date in cell A2 to the next Monday or a date of your choice you can then come back to the summary worksheet and copy the formula in B2 down one row with the fill handle you then just type in the name of the new worksheet and you have the total hours from that worksheet now to add more weeks just repeat this very same process how amazing is that I'd say it's pretty amazing and if you want to continue building amazing things then check out this video on how to build an awesome task tracker in Google Sheets thank you for watching like this video if you had fun and subscribe if you learned something new and as always I will see you again in the next spreadsheet life video