- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 02, 2024 08:20 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 03, 2024 06:08 AM
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.
