Help

Date add option

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
1175 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 !