|
#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. 
|
|
#2
03-11-2012, 03:30 AM
|
|||
|
|||
|
i found this but the formulas dont work for me. let me know if you figure it out. once they are separated can graph and pivot anything.
http://www.glucosebuddy.com/forum/sh...ighlight=excel
|
|
#3
06-03-2012, 03:53 PM
|
|||
|
|||
|
I think I figured out how to do it. Check my post at
http://www.glucosebuddy.com/forum/sh...=8334#post8334
|
 |
|
|
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 |
Linear Mode
