Excel in how the two add up to a few seconds? ? Urgent!!! Urgent!! Urgent!!!

For example,
ABCD
1 0 minutes and 36 seconds 1 minute 5 seconds
2 1 minutes and 18 seconds 1 minute and 38 seconds
3 1 minute and 36 seconds 1 minute 24 seconds
4 2 minutes 5 seconds 2 minutes and 40 seconds

I would like to obtain the results of A1 + B1, how do? Said detailed some of the best, thank you!!


to pure numbers can sum.
you put them into digital, the other in an empty cell Negri, playing = sum (A1, B2), what format you want the results?
is the time format, or numerical format?

as long as the cell format as “digital” or “time” format on the trip formula
direct input will be able to add to the formula cell Format is also set to “time” or “digital”

input, but the time when we should pay attention:
10 minutes and 36 seconds should be written in 0:10:36,
If you use direct text input, Be seen as a text format that can not be calculated in accordance with the time when they enter if the input format, you can add up, as if the text was not.A little trouble on the point.

Leave a Reply