To set up the columns to track time data, click in cell A1 and type "Clock In." Click in B1 and type "Clock Out." Click in C1 and type "Total Hours." ...

Step 2: Set Your Time Data Type . Before you add any calculations or checkboxes, you need to tell Excel that certain columns ...

The best new tool from Microsoft Excel is undoubtedly the SCAN function. Here's how to use it to calculate running totals. Find the full guide at Spreadsheet Point.

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.