Exporting details, Formatting the date/time column in excel – Measurement Computing USB-5100 Series User Manual
Page 48

USB-5100 Series Software Help
Modifying a Plot
To return to the original sort order, click the Restore Order button
. Note that if you have the export
preferences set to
Use export ordering rules,
then the series is listed in the order defined in that preference
when you click the Restore Order button. If the data file contains series with measurement types that are
not defined in the export ordering rules preference, then those series are listed after the defined series.
6. Click
Export
and then select where you want to save the file.
7. Click
Save
. You can now open the exported file in Excel or another software application.
Exporting Details
You can export the information in the Details pane to a text file, which can be opened in any text editor or
imported into numerous applications, such as Microsoft Word or Excel.
To export details, complete the following steps:
1. Make sure the Details pane includes the series you want to export. This might include series pasted from
other data files or series derived through filters
2. Select
File»Export Details
.
3. Accept the default file name, or type a new name.
4. Click
Save
.
Formatting the Date/Time Column in Excel
In Excel, dates and times for each data point may initially appear as ####### and times may not have seconds
listed.
To display the full date and time with seconds in Excel, complete the following steps:
1. Adjust the time column width so you can see the whole date and time.
2. Select the time column from row 3 down.
3. Select
Format»Cells
.
4. Select the
Custom
category and then select
m/d/yyyy h:mm
as the type.
5. Add
:ss
(or
:ss.000
if you used a fast logging interval) to the end of the string in the
Type
field:
m/d/yyyy h:mm:ss
(normal logging interval)
m/d/yyyy h:mm:ss.000
(fast logging interval)
6. Click
OK
. The seconds should be listed automatically.
To export the date and time in separate columns, go to
Preferences»General»Export Settings
Date and time format: Separate into two columns
option.
48