Date add option

[JeremiBen]

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

[lindseypuccio · Accepted solution]

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]

Hi, 

The solution work, thank you for this. 

I'm not sure why though 😀

Awesome support airtable !