![create a work clock in hours spreadsheet in excel create a work clock in hours spreadsheet in excel](https://clockify.me/assets/images/excel-timesheet/excel-timesheet-guide-1.png)
On the Home tab, in the Cells group, choose Format, and then choose Format Cells. To display the time as more than 24 hours, select cell B4. This is because the time for Task 2 is in 24-hour time.
![create a work clock in hours spreadsheet in excel create a work clock in hours spreadsheet in excel](https://clockify.me/assets/images/excel-timesheet/excel-timesheet-guide-3.png)
The result is 4:15, which is not what you might expect. Type =B2+B3 in cell B4, and then press Enter. In cell B2 type 12:45, and in cell B3 type 15:30. You need to apply a special format to the formula result. Well, that was easy enough, but there’s an extra step if your hours add up to more than 24. Press Enter to get the same result, 16 hours and 15 minutes. The formula will look like this: =SUM(B2:B3).
![create a work clock in hours spreadsheet in excel create a work clock in hours spreadsheet in excel](https://cdn.vertex42.com/ExcelTemplates/Images/timesheet-large.gif)
Select cell B4, and then on the Home tab, choose AutoSum. We provide three types of timesheet templates: Weekly timesheet, Bi-weekly timesheet, and Monthly timesheet.Tip: You can also add up times by using the AutoSum function to sum numbers. You can modify them according to your requirements, print them, and distribute them to your team.
#CREATE A WORK CLOCK IN HOURS SPREADSHEET IN EXCEL FREE#
These free timesheet templates help you track time within your company. They are available as Doc, Spreadsheet, and PDF. If you want to use a timesheet template but don't have time to create your own, use our free timesheet templates.