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.
In A1, enter Time In. In B1, enter Time Out. In C1, enter Hours Worked. Select A2 and B2, and press [Ctrl]1 to open the Format Cells dialog box. On the Number tab, select Time from the Category list box, choose 1:30 PM from the Type list box, and click OK.Right-click C2, and select Format Cells.On the Number tab, select Time from the Category list box, choose 13:30 from the Type list box, and click OK. In C2, enter the following formula: 1  In A1, enter Time In. 2  In B1, enter Time Out. 3  In C1, enter Hours Worked.4  Select A2 and B2, and press [Ctrl]1 to open the Format Cells dialog box. 5  On the Number tab, select Time from the Category list box, choose 1:30 PM from the Type list box, and click OK.ight-click C2, and select Format Cells. On the Number tab, select Time from the Category list box, choose 13:30 from the Type list box, and click OK. In C2, enter the following formula: 1  In A1, enter Time In. 2  In B1, enter Time Out. 3  In C1, enter Hours Worked.