We can see that the two times taken by the student to complete two different assignments are provided in cells: B2 and B3, and we wish to calculate the total time taken by the student in cell B4. Now, let’s say in the above example we wish to sum up more than 24 hours, where the time taken by the student to complete the first assignment is 15 hours and the time taken to complete the second assignment is 12 hours and 30 minutes: It works quite quickly as the given hours do not add up to more than 24. read more, and we get the desired result- 14 hours for completion of two assignments. The values can be numbers, cell references or ranges. It is categorized under the math and trigonometry function entered by typing “=SUM” followed by the values to be summed. So, we sum the two given times in excel using the SUM () function SUM () Function The SUM function in excel adds the numerical values in a range of cells.
We can see that the two times were taken by the student to complete two different assignments provided in cells: B2 and B3, and we wish to calculate the total time taken by a student in cell B4.
If we wish to calculate the total time taken by a student to complete two different assignments, when the student can complete the first assignment in 5 hours and 40 minutes, and the second assignment in 8 hours and 20 minutes:
#Write on 2 sheets at the same time in excel for mac download
You can download this Sum Hours Excel Template here – Sum Hours Excel Template Example #1
0 kommentar(er)
