How to Count Hours Worked in Excel. Excel has a number of formulas that enable you to count the time between two dates. You can specify that you would like to count the difference in hours by ...

Luckily, you can use Excel timesheet templates to record and track the time each project took. You can even automate the calculation of the charges based on your hourly rate for that client.

Excel lets you vary the calculations you perform on specified cells using a single formula. Here's a look at how the technique works and one good example of when you might want to use it.

Click "New" in the left pane. Click "Time Sheets" under Office.com Templates. Click on "Time Card" and then click the "Download" button. The Time Card template opens as a new Excel worksheet.