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:
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:
