Adding (sum of) Time values in Excel
Add Time fields the same as you would any other numbers. For example,
if you have a time of 2:10 in cell A1 and 2:15 in A2, you'll see 4:25 as
the total when you add the times together.
You won't see what you expect if the values add up to more than 24
hours, If you added 9:00, 8:00, and 8:00, you'd see 1:00. This is because
Excel is showing you the result in 24-hour notation ( 9 + 8 + 8 = 25
hours).
To see a result in total hours, you need to do reformat the result.
Instead of the h:mm format, use [h]:mm.
The brackets around the "h" prevent the result from displaying in
24-hour notation. The same will work for minutes [m] 25 hours formatted as
[m] will show a result of 1,500, (25× 60 = 1,500). |
or Angle Counter Clockwise
button 
.