Timing in ilogic

[Anonymous]

I have to submit monthly reports and part of that is 'how much time has been spent on files'. Basically at the beginning of a project we attempt to define the effort required to reach the end of the project. So a qty of 'time' is assigned for each stage in the project.

Can I create a rule that could manage this? ie a rule that when a file is created it starts a timer. The timer would pause/stop when the active window is closed. At this point the value is written to a spreadsheet.

On subsequent opening and closing events the time is then added to the previous time and updated.

I've had a look around and there is some code out there that shows timer functions that show how long a rule runs for. Could this be adapted to do as said above? start timer>do some form of dummy loop>stop timer on program exit etc...

I'm looking at the overall 'reporting' that I have to do and would like to automate most or if not all of this into a 'real time' spreadsheet in order that we can identify problems at an earlier stage.

thanks all 🙂 

[MechMachineMan]

An add-in would be best for this.