Adding Units of minutes and seconds

[Olive Oil Guy]

I am creating a recording log and would like to add the various recording times - i.e. 16 tracks of various times such as
1:35 and 2:46 and 1:22, etc.
When I of course add up sixteen various times they do not total properly.
Thanks - Dave,
The Olive Oil Guy

 

[joeu2004]

First, when you display the result of time arithmetic, use the cell format Custom [m]:ss or [m]:ss.000 . The bracketed [m] displays minutes greater than 59.

Second, if you enter 1m 35s as 1:35, Excel interprets that as 1h 35m. Enter 1m 35s as either 0:1:35 or 1:35.0 . You might need to reformat the cell as Custom [m]:ss . You might get away with m:ss; but [m]:ss can reveal mistakes. ("Defensive programming".)

Finally, be forewarned that fractional seconds like 1:35.678 are not displayed correctly in the Formula Bar. This has two consequences. First, we can see fractional seconds only after formatting the cell properly, for example [m]:ss.000 , and pressing Enter. Second, we cannot edit the time if we want to retain (or change) the fractional part. We must re-enter the entire value with the appropriate changes.