#1
|
|||
|
|||
problem with time in report download
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 |
#2
|
||||
|
||||
Hi
could you post a sample of the csv file please?
__________________
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 |
#3
|
|||
|
|||
csv file
Thanks for your prompt response.
I have attached the .xlsx file. |
#4
|
||||
|
||||
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
__________________
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 |
Tags |
excel 2010, time format |
Thread Tools | |
Display Modes | |
|
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 |