Select Max Timestamp

[CorpIT]

I’m building an app for time tracking. I’m trying to calculate a “steptime” column so that eventually I can create running totals of how long an employee was “clocked in” at work.

Essentially I need a calculation that takes the TIMENOW() and subtracts the employee’s last “Time In” timestamp so that I can tell how many minutes someone was at work.

[Aleksi · Accepted solution]

Something like IFS([Clock Type]=“Out”,[Timestamp] - MAX(SELECT(Timesheet[TimeStamp],AND([Date]=[_THISROW].[Date],[Clock Type]=“In”,[Employee]=[_THISROW].[Employee]))))