With your Versature 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) to hours, minutes, and seconds (i.e., 00:0025).
Our award-winning customer support team is here for you.Contact Support