How do I sum times that were imported

[americsg1]

Hello,

First time poster long time reader.

I've imported a dataset from another source that displays call information. The time field is in a Minutes:Seconds:Tenths format.

I've used the =ISTEXT() and the response is TRUE.

How do I format and sum the row to achieve the same results in the format described above?

Here is a sample:

136,729:59
155,378:19:0
145,418:22:0
133,033:04:0
108,164:12:0
100,328:06:0
82,588:12:0
168,118:23:0

 

[SkipVought]

Hi,

Parse into 3 columns using data/Text to Columns

Convert each column to days, as TIME values are in units of days.

Sum these results and FORMAT as TIME.

Skip,
[sub]
[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion! [/sub]

 

[americsg1]

That would work if the all cells contained the same number of characters.

As in the sample, the next to last cell has fewer minutes that the rest

 

[AnotherHiggins]

Choose colon as the delimiter - it doesn't matter how many characters there are between/before delimiters.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[americsg1]

Thank you both.