After a surging run last year, the share prices of some of Britainâs biggest and most profitable FTSE 350 firms have come under pressure during 2014.
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.
Step 2. Enter the title Total Hours in cell C1. Select cell C2 by clicking on it with your mouse. Related Reading: Various Count Functions in Excel. Step 3. Enter the formula =B2-A2 and press the Enter key to display the time difference between two cells.Change the cell format to hours by selecting the cell and clicking on the arrow next to the Number option, which is on the Home tab.tep 4. Count the total number of hours worked based on a single time unit by entering the formula =INT((B2-A2)*24) and then pressing the Enter key. The INT function enables you to count the total number of hours between two times and round down the total to the nearest hour.