AnsweredAssumed Answered

Calculate Field in Same Table

Question asked by JulioSandoval on Aug 4, 2017
Latest reply on Aug 4, 2017 by philmodjunk



I created an Audit log and I need to get certain calculations done. I will post a picture of what it currently looks like:


Screen Shot 2017-08-04 at 10.31.04 AM.png


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.