- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2025 12:33 PM
Hey everyone!
I’m running into a challenge while using Airtable in conjunction with Fillout forms. When using the duration field in Fillout, it only provides the exact times (start and end) rather than a length of time in between. To simplify things, I’ve limited entries to a start time and end time, assuming the event will occur on the same day.
Here’s what I’m trying to do:
•I’d like to create a formula in Airtable that takes the start date (provided in a date field) and combines it with the end time (from the duration field, which doesn’t have an attached date).
•The goal is to format the end time as part of the same day as the start date.
For example:
• Start Date: 2025-01-14 08:00 AM
•End Time: 10:30 AM
• Result: 2025-01-14 10:30 AM
How would I go about writing a formula that merges these fields correctly? Any advice or tips would be greatly appreciated!
Thank you in advance for your help!
For reference, here's the formula I've already tried:
DATETIME_PARSE(
DATETIME_FORMAT({Start Time}, 'YYYY-MM-DD') & "T" & DATETIME_FORMAT({Duration}, 'HH:mm'),
'YYYY-MM-DDTHH:mm'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2025 06:11 PM
Does this look right?
DATETIME_PARSE(
DATETIME_FORMAT(Start, 'DD MMM YYYY') & ' ' &
ROUNDDOWN(Duration/60/60, 0) & ':' &
MOD(Duration, 3600) /60,
'DD MMM YYYY hh:mm'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2025 05:36 AM
Thanks. We are getting closer as I am finally not getting an error. Which is helpful, but its still returning a weird result. The formula is in 'End Time Copy' so it should return the result of 5:00 p.m., but instead 12:00 p.m.
Any recommendations?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2025 10:04 PM
Hmm could you try updating both the Start date field and the End formula field to use the same timezone?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 16, 2025 04:08 AM
That was my first thought as well. Verified both fields to be EST.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 16, 2025 06:17 AM
Hmm could you DM me a read-only invite link to a base where this is happening? I can't replicate the issue I'm afraid
