Convert CDR talk time

1. Brekeke Product Name and version:2.4.4.8 Advanced

2. Java version: ver 6 update 18

3. OS type and the version: Windows 2003 server

4. UA (phone), gateway or other hardware/software involved: asterisk, mvts

5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/ ... terns.html : 9

6. Your problem:
I am uisng brekeke for whole sale sip traffic. Is there a means to store CDRs with talk time in second. Any one has an excel formula to convert to seconds. The style used not is very carrier friendly.

Use this at Excel
if D1 is 00:01:01, the above formula shows 61.

also... if you are providing a carrier service, I don't recommend that you use the default CDR information because it is a text based file..

You may need to use an advanced version because it has the radius client function which can provide a billing feature.

this is a old post, but i have the same purpose.
I want to get the seconds of the call.
I can see at Call Logs. If I Select Output Format CSV, when i open the result csv file with excel (or notepad), the column with seconds is not the expected. I get a number (but not talk seconds).
So the question remain the same as original:
How I get the seconds in CDR.
Thanks

taitan wrote:Use this at Excel

Code:

 =(HOUR(D1)*60+MINUTE(D1))*60+SECOND(D1) 

if D1 is 00:01:01, the above formula shows 61.

Put the following line in the [Configuration]->[Advanced] page.

--------------------------------------
file.log.session.date.str = true
--------------------------------------

And restart the server.