View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Adding mm:ss values

... or as [h]:mm:ss if the total might go beyond 24 hours, or as [mm]:ss if
you want the answer to appear as minutes & seconds.
--
David Biddulph

"Sean Timmons" wrote in message
...
you can just add them together and format your result cell as hh:mm:ss...

"Howard Kaikow" wrote:

I recently started using Comcast phone.

When I download lists of calls, the numbers are of the form
minutes:seconds

I'd like to add up those numbers.

Short of writing my own function, does Excel provide functions to do
this?