how can I add time that I entered in only minutes and seconds
Use the SUM function and format the cell as [mm]:ss.
=SUM(A1:A10)
Then format the formula cell as [mm]:ss
The [ ] keep the minutes from rolling over into hours.
Without the [ ] :
61 minutes 10 secnds would display as:
01:10
With the [ ] it would display as:
61:10
--
Biff
Microsoft Excel MVP
"greg" wrote in message
...
I have a series of times that are 11 minutes and less and want to add them
but cannot figure out how. I found the format [mm]:ss but don't know how
to
use it
|