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 recommend
How to Calculate Time on Excel Spreadsheet advise photo

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

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

picture How to Calculate Time on Excel Spreadsheet
pictures 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


The Best Of Shut Up Take My Money: 100th Edition
Neutral Nail Ideas That Look Good With Everything
The Most Divisive Colour Is Back in Fashion
How to Make Plant Pots with Shot Glasses
Survey Finds That Australian Drivers Hate Everyone
Acetaminophen
How to Make a Straw Boat
Cancer Screening Tests for Women
The Best Gym Bags For Men 2019
Eye Gloss Could Be Your New Shadow Blending Tool, As Seen AtAltuzarra
A woman claps back at people who couldn’t believe she landed her husband
6 Alternative Therapies to Help You Live Better With HIV
Daniel Johns Re-emerges For David Jones ShotBySound
How to Have Clear Skin Naturally



Date: 19.12.2018, 03:51 / Views: 93182