problem with time in report download

rlsamson · #1 12-04-2014, 12:15 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem creating visual report	shird	Project	2	03-18-2019 03:44 AM
Automation Process of Schedule Report Output and Report Check Score Card !	ozman86	Word VBA	1	11-19-2014 11:52 PM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in	tinfanide	Excel Programming	1	03-04-2012 12:05 AM
Font Problem with Richtextbox in MS Access Report	surendrababu	Office	2	11-29-2005 02:11 AM
access sub report problem	Robbi Young	Office	3	08-13-2005 10:47 AM