|
#1
10-08-2010, 03:44 PM
|
|||
|
|||
Exporting to Excel: Separating date / time fields on CSV files
I use PivotTables in Excel to organize my glucose logs. One of the easiest ways to filter log results is by date. However, I have noticed that date and time are together on the same line when I export the CSV file to Excel.
Is there an alternate way to separate the date and time fields, or, going forward, will the CSV file separate both the date and time so they're more easily filter-able and import-able into Excel? I could probably do some work with copying the dates and times out, and then using the Text Import Wizard with the space as a de-limiter, but I figured that it would be easier if date and time fields were separated. 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| date format | gdt | Glucose Buddy Specific (Questions/Support) | 1 | 01-29-2012 04:23 AM |
| Export to Excel | mhstar99 | Glucose Buddy Specific (Questions/Support) | 25 | 12-20-2010 05:40 AM |
| Log time | chloec | Glucose Buddy Specific (Questions/Support) | 0 | 09-14-2010 09:25 PM |
| Exporting logs to Excel. Can it be done? | clem | Glucose Buddy Specific (Questions/Support) | 1 | 08-30-2010 06:26 PM |
| Time To Go | hypoconsequence_blog | Blogs (Updated) | 0 | 08-20-2010 04:45 PM |
Threaded Mode