Hi my name is Dave Andrews and today I am going to show you how to create a time sheet. Let’s go to the computer and we are going to open up Microsoft Excel by clicking on the start button and going to all programs and we are going to find in here Microsoft Office and we are going to open Microsoft Excel. Now what we are going to do for our timesheet is let’s say we are going to record a weeks worth of work Let’s put down our days that we worked, basically Monday through Friday and this timesheet is going to calculate for us the amount of hours that we worked this week along with how much we want to get paid so what we want to do is create a formula first that will show the date. For Monday click in A2 and let’s give it the date of October 6th. Now we are going to have these other days automatically calculate based upon the original so to do that just say equals and click on A1 or rather A2 and say plus 2 and press enter.
As you can see Tuesday is automatically filled in. Click inside of B2 and select copy, let’s paste that for Wednesday, Thursday, and Friday. As you can see they are automatically filling in the information. Now let’s put in the number of hours that we worked. Say we worked eight hours Monday, eight Tuesday, Wednesday was a half day, Thursday and Friday were full days. Let’s calculate the total amount of time that we worked. To do so let’s say total worked hours, click in A6, press the equals sign and we are going to type sum and open parentheses click on A3 and drag your mouse all the way to e3 and let off. Now type a closed parentheses to finish out your formula and say enter. That totaled the amount of hours that we worked. Now let’s say amount per hour and we are going to say we make $30 an hour and let’s total that up by saying equals and clicking on A6 and saying times 30 and the times is a little asterisk.
Press enter so we made $1,080 this week. It’s that easy to create a timesheet. My name is Dave Andrews and I’ve just showed you how to create a time sheet. .
Create a time sheet by opening Microsoft Excel to create a formula that calculates information related to working hours and payment. Make a time sheet and keep track of important work records with tips from a software developer in this free video on general computer tips.
Expert: Dave Andrews
Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, he is employed by a government IT department.
Filmmaker: Tim Brown