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?