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.
Repeat this process with the ending date and time in cell B1. Related Reading: How to Calculate Overtime & Double Time in Excel. Step 3. Click on the cell where you want your result to appear, then enter =NETWORKDAYS(A1,B1)-1-MOD(A1,1)+MOD(B1,1), without the quotes.Press Enter to complete the function.croll down until you see the 37:30:55 option, which signifies that it will display time as a total number of hours, instead of cutting off and restarting at 24. Click OK and the total number of hours, except for weekends, that exist between your two sets of dates and times will appear.