RE: Adding mm:ss values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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?



.

Relevant Pages

  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)
  • Excel 07 - text displays as pound signs
    ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ... any given cell will suddenly appear as all pound signs. ... changed the format to a date. ...
    (microsoft.public.excel.newusers)
  • Re: Date and Time (entering in the format of mm/dd/yyyy and hh:mm:
    ... you can't format the difference to show mm ... Elapsed time is the difference between two times. ... In cell A1, ... On the Home tab, in the Cells group, click Format, and then click ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)