View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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