Welcome to the community, @Jennifer_Greyber!
This is very simple.
Create a “Duration” field and set it to the “Duration” field type.
Then, create an “End Time” field, which is a “formula” field type.
This is the formula to use:
DATEADD({Start Time}, {Duration}, 'minutes')
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question.
Welcome to the community, @Jennifer_Greyber!
This is very simple.
Create a “Duration” field and set it to the “Duration” field type.
Then, create an “End Time” field, which is a “formula” field type.
This is the formula to use:
DATEADD({Start Time}, {Duration}, 'minutes')
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question.
Hi ScottWorld! Thanks for your quick answer! Yes, that answers the question I asked. I do have a follow up question as well. Is there a way to create a formula that automatically updates the times (either start or end) if I change one or the other? In other words, if I tweak the schedule in some way, I’d like for all the times for that one day to update automatically instead of having to manually adjust each one. Does that make sense?
Thanks,
Jennifer
Glad I could help!
No, you wouldn’t be able to do that with formula fields, because formula fields can’t have their values edited. So that situation would be more of a challenge… the only way to do that would be to switch back to a date field (instead of a formula field), and then create some sort of automation to automate the process somehow. Perhaps by using Airtable’s built-in automations, or maybe a custom JavaScript, or perhaps with Integromat or Zapier.
Glad I could help!
No, you wouldn’t be able to do that with formula fields, because formula fields can’t have their values edited. So that situation would be more of a challenge… the only way to do that would be to switch back to a date field (instead of a formula field), and then create some sort of automation to automate the process somehow. Perhaps by using Airtable’s built-in automations, or maybe a custom JavaScript, or perhaps with Integromat or Zapier.
Thank you! Automations sound interesting but probably not necessary at this point for our event.
Jennifer