Calculating time in MS-Excel



Community Tested

Why choose wikiHow?
When you see the green checkmark on a wikiHow article, you know that the article has received careful review. In this case, we tested the instructions on our own devices and confirmed that the instructions worked.

How to Calculate Time on Excel Spreadsheet

Two Methods:

This wikiHow teaches you how to create a time sheet for payroll in Microsoft Excel. You can do this on both Windows and Mac computers by using a pre-made template or by creating your own time sheet.

Steps

Using Templates

  1. Open Microsoft Excel.It's a dark-green app with a white "X" on it.
  2. Click the search bar.It's at the top of the Excel window.
    • On Mac, first clickFilein the upper-left corner, then clickNew from Template…in the drop-down menu.
  3. Typetime sheetinto the search bar and pressEnter.This will search Microsoft's database of templates for time sheet templates.
  4. Select a template.Click on a template that you want to use. Its page will open, allowing you to view the template's format and appearance.
    • If you decide that you don't like the template that you've selected, clickXin the template's window to close it.
  5. ClickCreate.It's to the right of the template's preview. Doing so will create the template in Excel.
  6. Wait for your template to load.This will likely take a few seconds. Once the template loads, you can proceed with creating the time sheet.
  7. Enter any necessary information.Each template will vary slightly from other templates, but you'll typically have the option of entering the following:
    • Rate per hour- The amount that you're paying the employee in question per hour of work.
    • Employee identification- Your employee's name, ID number, and so on.
  8. Enter the time worked in the appropriate column.Most time sheets will have the days of the week listed in a column on the far-left side of the page, meaning that you'll input the hours worked in the "Time" (or similar) column to the right of the "Days" column.
    • For example: if an employee worked eight hours on a Monday during the first week of a month, you would find the "Monday" cell in the "Week 1" column and type in8.0.
  9. Review the results.Every time sheet template will calculate the total number of hours that you enter and, if you've entered a rate per hour value, display the total that the employee in question earned.
  10. Save your time sheet.To do so:
    • Windows- ClickFile, clickSave As, double-clickThis 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 clickSave.
    • Mac- ClickFile, clickSave 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 clickSave.

Creating a Manual Time Sheet

  1. Open Microsoft Excel.Its app icon resembles a white "X" on a dark-green background.
  2. ClickBlank workbook.This white icon is in the upper-left side of the Excel "New" page.
    • Skip this step on a Mac.
  3. Enter your headers.Type the following headers into the following cells:
    • A1- Type inDay
    • B1- Type inWeek 1
    • C1- Type inWeek 2
    • You'll addWeek [number]in theD1,E1, andF1(if necessary) cells as well.
    • If you observe overtime, you can add anOvertimeheading in cellC1for Week 1, cellE1for Week 2, and so on.
  4. Enter your days of the week.In cellsA2throughA8, type inSundaythroughSaturdayin order.
  5. Add a rate.TypeRateinto cellA9, then enter the rate per hour in cellB9. For example, if the rate is .25 per hour, you'll type15.25into cellB9.
  6. Add a "Total" row.TypeTotalinto cellA10. This is where the total number of hours worked will go.
    • If you want to use overtime as well, typeOvertimeintoA11and enter the overtime rate intoB11.
  7. Enter the formula for Week 1.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 beB10.
    • Type in=sum(B2:B8)*B9and pressEnter.
  8. Enter the formula for the remaining weeks.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 theB2:B8section 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 theB9value withB11. For example, if your Week 1 "Overtime" column is in columnC, you'd enter=sum(C2:C8)*B11into cellC10.
    • If you're using overtime, you can create a "Final Total" section by typingFinal Totalinto cellA12, typing=sum(B10,C10)into cellB12, and repeating for each "Week [number]" column with the correct column letters.
  9. Fill out the time sheet.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.
  10. Save your time sheet.To do so:
    • Windows- ClickFile, clickSave As, double-clickThis 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 clickSave.
    • Mac- ClickFile, clickSave 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 clickSave.

Community Q&A

Search
  • Question
    How do I enter floating holidays or vacation days, if I work part time (4.5 hours)?
    wikiHow Contributor
    Community Answer
    Enter 4 1/2.
    Thanks!
Unanswered Questions
  • What formula do I use if I want to use clock in-clock out and 30 minute luch if >=6 hours?
  • How do I create a cell at then end that shows the projected punch out time on Friday to stay at 40 hours/week?
  • How do you add 15 minutes to a time in a cell?
  • Where do I add the breaks?
  • How do I find the average of times total staff worked for a month?
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
  • As a general rule, using a template in Excel and tweaking it to fit your preferences is much easier than creating your own spreadsheet from scratch.

Warnings

  • Always save your work, especially when dealing with employee finances.

Related wikiHows

Article Info

Categories:

In other languages:

Español: , Italiano: , Português: , Русский: , Deutsch: , Français: , Bahasa Indonesia: , Nederlands: 

Thanks to all authors for creating a page that has been read 344,884 times.





Video: How to Solve 4 Frustrating Time Calculations in MS Excel 200

How to Calculate Time on Excel Spreadsheet
How to Calculate Time on Excel Spreadsheet images

2019 year
2019 year - How to Calculate Time on Excel Spreadsheet pictures

How to Calculate Time on Excel Spreadsheet advise
How to Calculate Time on Excel Spreadsheet recommend photo

How to Calculate Time on Excel Spreadsheet pics
How to Calculate Time on Excel Spreadsheet pics

How to Calculate Time on Excel Spreadsheet How to Calculate Time on Excel Spreadsheet new images
How to Calculate Time on Excel Spreadsheet new images

foto How to Calculate Time on Excel Spreadsheet
foto How to Calculate Time on Excel Spreadsheet

Watch How to Calculate Time on Excel Spreadsheet video
Watch How to Calculate Time on Excel Spreadsheet video

Forum on this topic: How to Calculate Time on Excel Spreadsheet, how-to-calculate-time-on-excel-spreadsheet/
Discussion on this topic: How to Calculate Time on Excel Spreadsheet, how-to-calculate-time-on-excel-spreadsheet/ , how-to-calculate-time-on-excel-spreadsheet/

Related News


Keanu Reeves to have paternity test
Brett has not told the truth
21 Stunning Burgundy Nails Designs That will Conquer Your Heart
10 Fall 2019 Back to School Staples for Adults
Burberry To Stop Using Fur And Burning Unsold Stock
How to Design a Life of Your Choice
Piccolo manuale della seduttrice: le tecniche per conquistare chi ti piace e farlo tuo in un istante
How to Be a Data Scientist
Ferrous Fumarate-Folic Acid Reviews
Copenhagen, Denmark
Youre Going to Want to Add Everything From Shopbops Sale to Your Cart ASAP



Date: 06.12.2018, 07:50 / Views: 33162