AnsweredAssumed Answered

Calculate Field in Same Table

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

Hello,

 

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.

Outcomes