Skip to main content

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

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!

Hi, 

The solution work, thank you for this. 

I'm not sure why though  😀

 

Awesome support airtable !

Reply


Terms & Conditions