GETLOGOTIME

Summary

Retrieve time data from a Siemens LOGO! module. This function is available via the taskpane as well as directly via the cell “=GETLOGOTIME(…)”


Return Value

The returned value depends on the chosen time query, see below.


Arguments

ip – Specifies the ip address of the LOGO module.

query – Specifies the specific time data to be obtained, following queries are available:

  • YEAR – Actual year of the LOGO module.
  • MONTH – Actual month of the LOGO module.
  • DAY – Actual day of the LOGO module.
  • HOUR – Actual hour of the LOGO module.
  • MINUTE – Actual minute of the LOGO module.
  • SECOND – Actual second of the LOGO module.
  • DATE_AND_TIME – Actual date and time of the logo module. Don’t forget to change the cell format to a desired date or/and time format in Excel to make the value readable.

Example


Instructional Video