Hi! Is it possible to set a time in a date/time function? I have a formula field that calculates due dates for tasks. I would like to create an automation that will email the task owner (a sponsor who does not have airtable access) a Google Calendar invite on the due date so that it is on their calendar. Is it possible to do this without creating extra Date/Time formula fields for the start and end time of the task?
Current Formula: WORKDAY(Date,-30)
If this is not possible, can you add to that formula to determine a start time of 9:00AM and end time of 9:05AM so that I can get this on their calendar?