With your net2phone Canada Google Sheets add-on, Call Record Details (CDRs) have recorded call durations in seconds, but you can easily convert your data to hours and minutes using the following steps:
5. Press enter to convert the formula to a number.
6. Ensure the cell or column with your new number is selected and click Format > Number > Duration.
7. Drag the corner on your formatted duration cell down the column for any other rows you want to also apply the formula.
Your new column will have the recorded second-duration (i.e., 25) coverted to hours, minutes, and seconds (i.e., 00:00:25).
Our award-winning customer support team is here for you.Contact Support