Excel formula to convert talk length to seconds
Use the following formula in excel to convert the talk length in column D of exported SIP Server call log file to seconds.
=======================================
=(HOUR(D1)*60+MINUTE(D1))*60+SECOND(D1)
=======================================
if D1 is 00:01:01, the above formula shows 61 in seconds.