Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 36)

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
28
You can customize default format strings using any valid Excel format
codes from the Format Cells dialog box in Excel. For example, German
equivalents of General and dd-mmm-yyyy hh:mm:ss are Standard and TT-
MM-JJJJ hh:mm:ss, respectively.
You can also apply individual time and date formatting to any spreadsheet
cell, including those containing FactoryTalk Historian DataLink functions,
by choosing Format > Cells > Number. See your Excel documentation
for more information on formatting dates and times.