Revision history [back]

You can calculate the total number of hours worked per week for a specific task in Excel by following these steps:

1. Open a new or existing Excel worksheet.

2. Create a table that shows the start and end times for each day of the week for the specific task.

3. In a new column, subtract the start time from the end time for each day to calculate the total number of hours worked for that day.

4. Use a sum formula to add up the total number of hours worked for the week. For example, if your hours worked per day are in column B, you can use the formula =SUM(B2:B8) to add up the total hours for the week.

5. Format the result to display as a time value by selecting the cell with the formula, then going to the Home tab, and clicking on the drop-down arrow next to the Number Format button. From there, select the Time option and choose the format that works best for your data.

6. Repeat these steps for any additional tasks or projects that need to be tracked in Excel.