In the cell where you want the total hours worked, enter the following formula: =end time - start time. So, in our example, we would enter =5:00 PM - 9:00 AM. When you hit enter, you should see the total hours worked for that day. You can then repeat this process for each day you want to track.