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.
- What causes the format to be broken?
- Why is the ‘ added to the beginning of each cell when it is formatted?
- 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?