Your manager has requested you keep a timesheet showing how many hours you work each day and what projects you work on during that time. Using spreadsheet software, how can you total your hours at the end of each week to provide a quick and accurate amount?

Use the SUM function to add the hours recorded for each day of the week. For example, if daily totals are in cells B2 through B6, enter =SUM(B2:B6) to calculate the weekly total. MIN and MAX find the smallest and largest values, while AVERAGE calculates the mean, so neither gives the total hours worked.

AI-written and checked against the verified answer.