In Microsoft Office Excel, you can perform calculations on data in hours, minutes, and seconds format. If you need to calculate the time, use the appropriate formulas for this.
Instructions
Step 1
If this is your first time encountering the task of timing, try not to resort to complex functions right away. Most calculations can be done with simple mathematical formulas: addition and subtraction. And be sure to give the cells the correct format.
Step 2
To do this, select the range of cells into which the data will be entered, and right-click on the selection, or open the "Home" tab and click the "Format" button in the "Cells" toolbar. In both the first and second cases, select the "Format cells" item in the context menu.
Step 3
A new dialog box will open, make sure you are on the Number tab. In the list located in the left part of the window, select the "Time" item with the left mouse button. In the right part of the window, specify in what form the time should be presented. Click on the OK button to confirm your choice.
Step 4
Enter data in the cells in the format XX: XX (or XX: XX: XX). To calculate the time interval between the first and second value, place the cursor in the cell where the total value appears. In the formula bar, put an equal sign, click on the cell with the last value with the left mouse button, enter the minus sign, then click on the cell with the first value. Press the Enter key.
Step 5
For example: the elapsed time from 11:10:15 to 12:30:00 is 1 hour, 19 minutes and 45 seconds. The total value in cell C2 is calculated by the formula: = B2-A2. If you need to count the time span in several rows (A3 and B3, A4 and B4, and so on), simply drag the autocomplete marker from cell C2 to the end of your table column (C3, C4).
Step 6
If you need to calculate how many total hours, minutes and seconds it took for something, simply add the data obtained in the above way using the SUM function. Place the cursor in the cell with the total value, click on the fx button, in the window that appears, select the SUM function with the left mouse button and mark the range of cells that will participate in the calculation. Press the Enter key. The formula for the calculation will look like this: = SUM (C2: C4).
