Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date add option

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1478 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JeremiBen
5 - Automation Enthusiast
5 - Automation Enthusiast

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 ? 🙂

1 Solution

Accepted Solutions
lindseypuccio
Airtable Employee
Airtable Employee

Hey @jeremie 

  1. Convert your Duration field in the lookup to formatting as a number. This should automatically turn it into "Duration in Seconds". 
  2. Create a new formula field "Duration in Minutes" that turns that duration in seconds into duration in minutes: {Duration in Seconds}/60
  3. 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!

See Solution in Thread

2 Replies 2
lindseypuccio
Airtable Employee
Airtable Employee

Hey @jeremie 

  1. Convert your Duration field in the lookup to formatting as a number. This should automatically turn it into "Duration in Seconds". 
  2. Create a new formula field "Duration in Minutes" that turns that duration in seconds into duration in minutes: {Duration in Seconds}/60
  3. 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!
JeremiBen
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, 

The solution work, thank you for this. 

I'm not sure why though 😀

 

Awesome support airtable !