General Tech Information

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.

Yes No
Suggest Edit