- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 10, 2024 06:59 AM
Hi,
I have a column with a date and time (starting date and time) in one tab and another column (Duration time) with a duration in another tab. I created a lookup in order to use this duration in a formula to get the endin date and time.
I couldn't figure out why my formula is not working...
Help ? 🙂
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 10, 2024 09:59 AM - edited Jan 10, 2024 10:00 AM
Hey @jeremie
- Convert your Duration field in the lookup to formatting as a number. This should automatically turn it into "Duration in Seconds".
- Create a new formula field "Duration in Minutes" that turns that duration in seconds into duration in minutes: {Duration in Seconds}/60
- Create a formula field:DATEADD({Start Date and Time}, {Duration in Minutes}, 'minutes')
Let me know if that works! And make sure that the time zone matches for all!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 10, 2024 09:59 AM - edited Jan 10, 2024 10:00 AM
Hey @jeremie
- Convert your Duration field in the lookup to formatting as a number. This should automatically turn it into "Duration in Seconds".
- Create a new formula field "Duration in Minutes" that turns that duration in seconds into duration in minutes: {Duration in Seconds}/60
- Create a formula field:DATEADD({Start Date and Time}, {Duration in Minutes}, 'minutes')
Let me know if that works! And make sure that the time zone matches for all!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 11, 2024 07:48 AM
Hi,
The solution work, thank you for this.
I'm not sure why though 😀
Awesome support airtable !
