Excel statistics phone call duration

Now, you can view your call details on the Internet and download them as an excel file. After studying this, you can use excel to calculate the actual call duration.
 
 
 
The excel Formula is as follows: when the D2 column (12 seconds) is calculated, the result is 1; when the D3 column (5 minutes 8 seconds), the result is 6.
 
= If (ISNUMBER (FINDB ("points", D2), MID (D2, 1, FINDB ("points", D2)-1), 0) + if (ISNUMBER (FINDB ("seconds", D2), 1, 0)
 
No. business type start time call duration call type
2 voice calls: 19:48:32
3. voice calls: 20:55:09
4 voice calls: 21:04:01
5 voice calls: 21:06:17
8. voice calls: 18:46:24
9 voice calls: 18:46:52

From Xiaoxu's technical blog