As long as you have a start time and an end time, Excel will be able to count the hours between them. 1. Open your Excel spreadsheet. Insert the title In in cell A1 and the title Out in cell B1. Enter the start time in cell A2 and the end time in cell B2. 2. Enter the title Total Hours in cell C1.