How to convert the timestamp into date and time

A timestamp is a set of characters that allow the storage of the date and time when a specific event occurs. In some Treetech equipment, the timestamp is given by three registers: Timestamp (H), Timestamp (M), and Timestamp (L). The information, in milliseconds, is formed by these three concatenated registers.

To get the current date and time indicated by the timestamp, convert the result of the above equation to date/time format and add to 01/01/1970 00:00:00. To make the process more transparent and make it easier, we provide a spreadsheet below where the conversion can be done directly.