| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import csv data and convert to TIME format
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 text data remains untouched even if I have previously formatted cells A1A3 as [h]:mm:ss If I manually overtype the cells ie in A1 (eg type 1:0:12, and 13:15:59 and 124:42:13) the cells display correctly (except no leading zeros) and the formula then starts to calculate correctly . In effect I am retyping every cell value so that the formula calculates correctly. Any help very much appreciated.  -- JLettington ------------------------------------------------------------------------ JLettington's Profile: http://www.excelforum.com/member.php...o&userid=30829 View this thread: http://www.excelforum.com/showthread...hreadid=504940 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert data into standard military time format | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| CONVERT DATA TO CURRENCY FORMAT | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
