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.
Solved! Go to Solution.
Something like IFS([Clock Type]=“Out”,[Timestamp] - MAX(SELECT(Timesheet[TimeStamp],AND([Date]=[_THISROW].[Date],[Clock Type]=“In”,[Employee]=[_THISROW].[Employee]))))
Something like IFS([Clock Type]=“Out”,[Timestamp] - MAX(SELECT(Timesheet[TimeStamp],AND([Date]=[_THISROW].[Date],[Clock Type]=“In”,[Employee]=[_THISROW].[Employee]))))
User | Count |
---|---|
37 | |
26 | |
23 | |
17 | |
14 |