Import csv data and convert to TIME format

J

JLettington

I import data representing telephone call duration from a csv file
ie
001:00:12
013:15:59
124:42:13
and want to sum it using SUM(A1:A3)

If I copy from the csv file and paste into Excel the format of the tex
data remains untouched even if I have previously formatted cells A1>A
as [h]:mm:ss

If I manually overtype the cells ie in A1 (eg type 1:0:12, and 13:15:5
and 124:42:13) the cells display correctly (except no leading zeros) an
the formula then starts to calculate correctly . In effect I am retypin
every cell value so that the formula calculates correctly. Any help ver
much appreciated.:confused
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

numbers convert to formula in csv 2
Lookup and average data in an unsorted list 1
Formula to match different ranges of time and prices 0
Help with time formats in Excel 2007, 0
CSV Data/Import Issues 1
Use SUM to add time format 6
Convert data into proper time format 1
Import CSV Data from Outlook Public Folder 0

Top