Summarize this article:

Its app icon resembles a white "X" on a dark-green background. This white icon is in the upper-left side of the Excel "New" page. Skip this step on a Mac. Type the following headers into the following cells:   A1 - Type in Day   B1 - Type in Week 1   C1 - Type in Week 2  You'll add Week [number] in the D1, E1, and F1 (if necessary) cells as well. If you observe overtime, you can add an Overtime heading in cell C1 for Week 1, cell E1 for Week 2, and so on. In cells A2 through A8, type in Sunday through Saturday in order. Type Rate into cell A9, then enter the rate per hour in cell B9. For example, if the rate is $15.25 per hour, you'll type 15.25 into cell B9. Type Total into cell A10. This is where the total number of hours worked will go. If you want to use overtime as well, type Overtime into A11 and enter the overtime rate into B11. This formula will add up the hours worked from Sunday through Saturday and then multiply the sum by the rate. To do this:  Click the Week 1 "Total" cell, which should be B10. Type in =sum(B2:B8)*B9 and press ↵ Enter. To do so, simply copy the formula that you entered for Week 1, then paste it into the "Total" row below your selected week and replace the B2:B8 section with your week's column letter (e.g., C2:C8).  If you're using overtime, you can use this formula to calculate overtime by replacing the B9 value with B11. For example, if your Week 1 "Overtime" column is in column C, you'd enter =sum(C2:C8)*B11 into cell C10. If you're using overtime, you can create a "Final Total" section by typing Final Total into cell A12, typing =sum(B10,C10) into cell B12, and repeating for each "Week [number]" column with the correct column letters. Enter the hours worked for each day in the "Week 1" column. You should see the hours and the respective amount earned total up at the bottom of your sheet in the "Total" section. If you have overtime enabled, fill out this column as well. The "Final Total" section will change to reflect the regular wages and the overtime combined. To do so:   Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type the document's name (e.g., "January Time Sheet") into the "File name" text box, and click Save.  Mac - Click File, click Save As..., enter the document's name (e.g., "January Time Sheet") in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save.
Open Microsoft Excel. Click Blank workbook. Enter your headers. Enter your days of the week. Add a rate. Add a "Total" row. Enter the formula for Week 1. Enter the formula for the remaining weeks. Fill out the time sheet. Save your time sheet.