Time Tag Date Conversion Instructions
-
Download Time Tag data to csv and open in Excel
-
Insert a column to the right of date and Title the Column “New Date”
-
Select all Dates in the “Date” column ie: from e2 …. To the bottom
-
Under the Data tab in Excel - Choose Text to Columns
-
Select delimited text - then choose next
-
Check the box “Other” and enter a / in the empty box
-
Deselect the check box on tab
-
Then choose next
-
Choose destination in the spreadsheet
-
Choose 3 columns, ie: M2 to O2
-
Click on finish
-
This has split your date data into 3 columns
-
Click in probably F2 the first empty cell in your blank column you inserted in step 2 above
-
Start your formula:
-
=m2&”/”&n2&”/”o2
-
Hit enter and you should have an American Date format
-
Fill the formula down, double click the blue dot in the bottom right of F2 and it will fill down automatically.
-
Then delete the old date column probably column E
-
Then proceed to Time Tag instructions