macOS AppleScript Help, File Usage Monitoring

[woodlandprinter]

I am trying to make a script of my own that will do the following, however I have not a clue where to begin.

I need it to do:

• Record each files name as it is opened, perhaps in an Excel file.
• Record the time that it is opened.
• Record the time once it is closed.
• It would be best to save and close the excel file each time it writes in a new value.

I would want it to put the info in each column, that way I can simply have Excel total up the time per instance that each file was open.

Thanks for any help you can give,

WP