Skip to main content

Hi Airtable community,



This is my first time using Airtable, so sorry if this is simple!



I am trying to set a ‘finish time’ by taking the booking date & time and adding the ‘duration’ too it which is coming from a lookup from another table.



Naturally the ‘End time’ should be “22:30” and “22:57”, yet all it’s doing is mirroring the start time.



I have tried the Dateadd function which I found in someone else’s post (see code below) but haven’t been able to get it working.



Am I missing something?


Thanks in advance!



DATEADD({Booking Date & Time}, Duration, 'hours')



Thanks in advance for posting your question! When someone provides an answer, remember to mark their reply as the ✅ solution.

Hi @Frazer_McLeod,



I think you have a formatting issue. Make sure the duration is seen as hours in the Duration field.



BR,


Mo

Hi @Frazer_McLeod,



I think you have a formatting issue. Make sure the duration is seen as hours in the Duration field.



BR,


Mo


Hey @mohamed_swellam, thanks for your quick reply.



The duration is set to h:mm in both the table and the lookup field. Any other ideas?



Thanks

Hey @mohamed_swellam, thanks for your quick reply.



The duration is set to h:mm in both the table and the lookup field. Any other ideas?



Thanks


Hi @Frazer_McLeod,



It appears that the correct formula is DATEADD(Date, Duration, 'seconds') as the duration field outputs its data in seconds to any formula.

Reply


Terms & Conditions