Configure Advanced Excel Options Dialog Box

In the configuration dialog box of the Write To Measurement File Express VI, select the Microsoft Excel (.xlsx) option from the File Format section and click the Advanced button to display this dialog box.

Use this dialog box to specify the time format for the data you want to write to a Microsoft Excel file.

Note LabVIEW ignores all options in this dialog box if you select the Empty time column option in the configuration dialog box of the Write To Measurement File Express VI.

This dialog box includes the following components:

Option Description
Absolute

Specifies whether you want to use relative time or absolute time for the data. If you place a checkmark in this checkbox, this Express VI writes the timestamp by using the time when you acquired the data. If you remove the checkmark from this checkbox, this Express VI writes the timestamp in terms of the time elapsed since 12:00 a.m., January 1, 1904, Universal Time [01-01-1904 00:00:00]. This checkbox contains a checkmark by default.
Format

Specifies the format of the timestamp you want to use in the Excel file.

Use the following codes to format dates.

Date Format Code
Months 1-12 m
Months 01-12 mm
Months Jan-Dec mmm
Months January-December mmmm
Months J-D mmmmm
Days 1-31 d
Days 01-31 dd
Days Sun-Sat ddd
Days Sunday-Saturday dddd
Years 00-99 yy
Years 1900-1999 yyyy

Use the following codes to format times.

Time Format Code
Hours 0-23 h
Hours 00-23 hh
Minutes 0-59 m
Minutes 00-59 mm
Seconds 0-59 s
Seconds 00-59 ss
Time 4 AM h AM/PM
Time 4:36 PM h:mm AM/PM
Time 4:36:03 P h:mm:ss A/P
Time 4:36:03.75 h:mm:ss.00
Elapsed time (hours and minutes) 1:02 [h]:mm
Elapsed time (minutes and seconds) 62:16 [mm]:ss
Elapsed time (seconds and hundredths) 3735.80 [ss].00
Delimit codes with a / (slash), - (hyphen), or . (period).
Note Hundredths must be delimited with a . (period).

The following table lists commonly used timestamp formats:

Date Format Time Format
yyyy/mm/dd
hh:mm
yyyy-mm-dd
hh:mm:ss
yyyy.mm.dd
hh:mm:ss.000
mm/dd/yyyy
dd/mm/yyyy