Calculate difference in time from a 'Created time' field across two rows

Hello, all Airtablers,
I’ve created a simple ‘Clocking In/Out’ Airtable for a colleague to track staff signing in and out. It uses a simple form where the user selects their name from a single select field and then selects either ‘In’ or ‘Out’ from another single select field and then submits the form.

In the table itself, each member of staff should have an ‘In’ AND ‘Out’ record for each day with the automatically generated date and time. Now is there a way to calculate the difference on the ‘In’ and ‘Out’ times for that staff member for that day as the values are on different records?

Did you end up finding an answer for this?! I’m struggling with the same issue. @Michael_Wood1

Hello,

No I didn’t. I can’t remember what I did in the end, some crude work around that didn’t quite achieve what I was after.