Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
1053 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Wood1
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2
Micky_Wolf
4 - Data Explorer
4 - Data Explorer

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.