Hey! We have a difficult airtable formula to create that outputs 1 or 0 based on how soon a date is. Could you tell me if you could help?
This is the problem:
We have a variable called {Deadline}, which is the deadline to respond to a job. We have a job board linked to airtable. However, this is also the deadline for us as recruiters do our work with the applicant. It's still up on the website even minutes before the deadline. So if someone responds, it's too late, which is frustrating for them. But we still would want them to apply in case we have the time.
So we need AT LEAST 8 hours (a 9:00 until 17:00 workday) * 60 minutes (for more accuracy) = 480 minutes to do our recruitment work. So we need a formula that says: IF we have less than or equal to 480 minutes of work during work hours until the deadline, the formula should be 1 (indicating to us that we should give a warning on the website when someone applies that we might not make it but will try). If it is already closed it should also just be 1 (it would be off the website, but just in case).
We work 9:00 until 17:00 Amsterdam time (The Netherlands) Monday till Friday. The deadlines can be anything: Thursday 23:59 (in which case it should be 1 at 9:00 that thursday, cause from then on, we have less than 480 minutes till 17:00).
If it closes on monday 14:00, then we have 5*60 minutes on monday and still need 3*60 minutes on the previous workday, which is friday, so it should be 1 from friday 14:00 onwards.
Let me know if anyone can help!