How to Do Time Sheets in Excel

A time sheet is a way of recording hours worked on a job or task. Time sheets can fine-tune your payroll processing and billing. There are different types of time sheets for payroll, billing, estimation and other management projects. Microsoft Excel templates offer a convenient way to start a time sheet system for your business: Simply download the template from Microsoft's website and you're ready to go.

Click "File," then "New." A new workbook window appears.

Click "Time Sheets" in the left-hand column.

Double-click an icon for the type of time sheet you'd like to create. For example, click "Monthly Time Sheet With Notes," "Weekly Time Sheet With Breaks" or "Biweekly Time Sheet." The time sheet downloads and opens in Excel.

Personalise the time sheet by entering your business information. For example, click on "[Company Name]" and then type your company name.

Modify the time sheet by clicking in a cell and typing the figure you need. For example, click on the "Time Out" cell and then type "10:45" to indicate that the employee clocked out at 10:45. Excel keeps track of hours and totals dynamically in most time sheets.


Try several time sheets to see which one suits your needs best before committing to using one permanently. As of November 2010, Excel features 50 different time sheets, so you're bound to find one that suits your needs.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Stephanie Ellen teaches mathematics and statistics at the university and college level. She coauthored a statistics textbook published by Houghton-Mifflin. She has been writing professionally since 2008. Ellen holds a Bachelor of Science in health science from State University New York, a master's degree in math education from Jacksonville University and a Master of Arts in creative writing from National University.

Try our awesome promobar!