Re: Time in / Time Out Field Analytics

347 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Hey Everyone!

I'm hoping you can help me out with a tricky one. We currently use a check-in system (VisitU for those that care) to keep track of when/why people use our space. I then take that data, dump it into airtable on a weekly basis and it does a bunch of cool analytic stuff already.

Now for my ask. It records a time in field (with an exact time like 15:57) but that is linked to a date field. I was tasked to figure out if being open past 6 is worth it on Monday's and Wednesday's. Figured out how to seperate the day of the week (using DATETIME_FORMAT(timeIn, 'ddd')) but now I want to give me a list of those who checked-in after 6 that I can then use the two field (Day Name and Time In After 6) to tell me how many people used our space. Make sense? Any ideas on how I could separate that time field? 

1 Reply 1
60*60*HOUR({timeIn}) + 60*MINUTE({timeIn}) + SECOND({timeIn})

This will give you the number of seconds into the day. Make a similar calculation for 6pm and then compare them.