Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
408 2
Showing results for 
Search instead for 
Did you mean: 

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

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


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.