Panasonic Home Business > Industrial Devices > Automation Controls Top > Service & Support > Frequently Asked Questions

How do I display the PLC calendar timer value in "YY/MM/DD" format on the spreadsheet?

ID:
851
Issued:
Dec 28th, 2009
Updated:
May 17th, 2013

How do I display the PLC calendar timer value in "YY/MM/DD" format on the spreadsheet?

ANSWER

This cannot be done unless you create an Excel Macro.
Use the calendar timer in special registers 9054 to 9056 to display the data in the following format on the Excel spreadsheet.

The date is January 13, 1999 and the time is 17:27:29
Date Time HEX display
January 13, 1999 17:27:29 Special register
54.2729
Special register
55.1317
Special register
56.9901
RELATED CATEGORIES

Did you solve your problems?

YES

NO

Search Keywords


If you still have problems with our products,

FEEL FREE TO CONTACT US

Return to top