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?

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?

... 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?

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
.. 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.

Thanx.

I tried both, neither did the deed.

"Howard Kaikow" wrote:
I tried both, neither did the deed.

If you want help, it would be useful if you provided some helpful
information. For example, a concrete example and, in this case, the results
after you "tried both [and] neither did the deed".

First, I wonder if the cells that you downloaded are formatted as Text.

Second, I wonder how you implemented Sean's suggestion ("just add them"):
using SUM, or use "+". They have different results when cells are formatted
as Text.

Third, if the cells are not formatted as Text, I wonder if what you think of
as "min:sec" was interpreted as hh:mm because there was only one colon in
the input. In that case, ironically, Sean's suggestion would yield
something reasonable and reveal the interpretation error more obviously than
David's suggestion (which would be better if the data were formatted and
interpreted correctly in the first place).

We could go down this complex troubleshooting tree and provide you with a
myriad of potential solutions, which you would have to try one by one and
report back for additional assistance.

Or you could provide some helpful information that will probably get you an
answer more expeditiously. The choice is yours.


----- original message -----

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
.. 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?

"JoeU2004" wrote in message
...
"Howard Kaikow" wrote:
I tried both, neither did the deed.

If you want help, it would be useful if you provided some helpful
information. For example, a concrete example and, in this case, the
results
after you "tried both [and] neither did the deed".

I have posted an example (twice),but,so far, neither has shown up in the
news reader.


First, I wonder if the cells that you downloaded are formatted as Text.

The downloaded file was a tab delimited text file.
I gave the file a .xls etension and then opened wit Excel.