I created an Audit log and I need to get certain calculations done. I will post a picture of what it currently looks like:
I need to gather the amount of time someone is spending by calculating either the TimeStamp field, or the ScriptStart Field etc.
Eventually, I want to split this up by time spent on each data source. There are three different ones in total.
I have seen some posts here about something similar but I haven't figured out yet where to start.
I tried creating a TO so I can subtract the timestamps but I need to subtract the previous one with the current one and so on.
Or if anyone has done it a different way, I am open to suggestions.
Thank you all for your time.