1 of 1 people found this helpful
You can do:
DATEDIFF('minute',[start date], [end date])
to get the difference between two dates.
But that means you want to shape the data so that the time is part of the date field.
In your case you'd have to do a LOOKUP to get the next row:
DATEDIFF('minute', ATTR([Date-time]), LOOKUP(ATTR([date-time]), 1) )
The "1" in the LOOKUP says to look forward one row.
Now you'll have values in minutes for each row (except the last row, which has no "next row" to look at.)
I can see some pitfalls in this. How will you know rows for Day-1 for employee-1 from Day-2 rows? You'll need to put some sort of indicator in the data to trigger that for you.