I am trying to evaluate my long distance plan with regards to free overseas calling.
My plan allows for free call to overseas numbers and costs $10.00 more per month for that option, (Vonage World Plan)
I can download a .csv file from the Vonage web site with the overseas calls sorted by number (011).


The duration field on the web site activity report is displayed as 31:30 (31 min 30 sec) or 12:02 (12 min 02 sec) or 03:59:07 ( 3 hrs 57 min 07 sec). When I import this file into excel these fields appear as 31:30:00 [1/1/1900 7:30:00 AM] or as 12:02 [12:02:00 PM] or 03:57:07 [3:59:07 AM].
I’m sure there is an easy way to display these fields in a form that represents the actual length of time in hours, minutes, and seconds, so that the total duration of calls can be calculated.
Unfortunately I have not been successful in finding that solution.
Thanks for any help,
Robert

Hi
could you post a sample of the csv file please?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for your prompt response.
I have attached the .xlsx file.

Attached Files

callActivity.xlsx (9.8 KB, 13 views)

Have you tried using the text to colmuns wizard to import?

Also try as follow : enter 60 in empty cell and copy it
slect the entire range with time
right-click - paste special - Divide - OK
custom format as [h]:mm:ss

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post