How can I add up call activity?

[djconfirm]

I’m trying to add up my vonage call activity. I downloaded the CSV from Vonage of the call activity and then opened it in LibreOffice Calc.

See attached example – sanitized for privacy purposes. [Apparently there is no way to provide a sample. Bummer.]
Once opened in calc, sort by direction of call.
Copy call duration column and open a formula using =sum() and insert the range of the outgoing calls.
Format the cells of the desired rows using the format code [HH]:MM to allow more than 24 hours to be accumulated.
Observe that the cells that were formatted to [HH]:MM, now have a leading apostrophe ‘ added at the beginning of each cell and the sum then fails. When the ‘ is manually removed from some cells, the sum appears to work for those rows.

1. What causes the format to be broken?
2. Why is the ‘ added to the beginning of each cell when it is formatted?
3. What’s the right way to do a sum of times that will add up to more then 24 hours?

Thanks much,
d
BTW, this is the lamest formatting system that I have ever seen. ha ha ha what a joke… With all the good ones out there, why did they pick this lame one? That’s ok I’m sure since no body reads any of this stuff anyway… THey are all still stick on email lists aren’t they?

[mariosv]

Hi @djconfirm, have you read in the help about how to open/import a CSV?, have you taken a look to documentation?
https://wiki.documentfoundation.org/Documentation/Publications

If you aren’t able to find out how to do it, please copy here a sanitized line of the CSV file.

[mariosv]

If you do the import properly usually you don’t find the ’
Have you set up columns with the proper format when importing?
In this case I think we don’t need an attachment, only copy and paste here.

[djconfirm]

As I said, I had no problem in importing the csv.
The problem was when I reformatted the time cells to [HH]:MM the ’ was added wrecking the sum.
Oh I see the attachment now. here is the sanitized example. Sorry not enough karma

• sigh…