Using Lookout 6.1
A couple of different issues.
I am using ETM to record pump run hours. This part works very well.
Where I run into problems is when I use a spreadsheet to record the values.
In the Spreadsheet1 object I set the ETM1 format to HH:MM and yet in the 'Spreadsheet1.csv ' pump 1 shows 2015:12:55 (Hours are right) but I don't understand why it will not transfer just HH:MM. Yet in the same Spreadsheet1 object I take another ETM2 and set the format to HH:MM it shows 52365:45 (Hours are right).
I then use Spreadsheet2 to grab the data once a month to record daily pump hours.
However if I try and and do any math formulas with ETM2 they do not work. (Formats are set HH:MM)
The ETM1 formulas work and takes the raw data 2015:12:55 and formats to HH:MM.
Does it stop working because the ETM reaches a too high number?
Side note: If I create a new ETM can I input hours somehow to reflect exsisting run hours?
