I've been scouring this forum for an answer to a variant of "Convert String to Duration" but alas, no simple answers uncovered!In my case, I have a text field that contains duration as as string such as, "1:30:00."I need this to now be a field that i...
I have a weird one: How would I even begin to convert a column that contains duration data formatted as a string like this? I want the final conversion to be a decimal number, but none of the standard DATETIME() type formulas can make sense of it. He...
I'm trying to use either a SEARCH() or FIND() function to locate a comma within a string. Unfortunately, these seem to be broken on Airtable right now. Am I missing something? This should be pretty straightforward, right?
I've searched on the community for solutions to combining one field that contains a date and another field with a duration to create a datetime field, but haven't come across any solutions to solve it. I'm using the DATEADD() formula but Airtable is ...
Hello,I've encountered an issue with the DATETIME_PARSE function not correctly converting a concatenated date and time from two fields. Is there something I'm missing?Results render time incorrectly.Datetime formula with a nested concatenation of two...
I apologize in advance for turning this into a rant within this thread but I'm frustrated with this latest offering:Our company has been using Airtable for over 5-years now and we love it. However, we have seen a noticeable turn away from what made t...
I managed to decipher a solution within this post. It came down to using the VALUE() function and dividing by desired unit of time (/3600 to yield hours).
@Mike_AutomaticN , I had thought of this. However, in this instance, it actually isn't an array but a single job title that contains a comma. This is why I was trying to isolate it using the formula. The formula works in the source table, but there s...
Counterintuitively, that was what worked. I think Airtable has a glitch with the Date field where, despite the format being set to Local, the time zone display forces GMT. Then for the formula you cannot use your correct timezeone - you have to also ...
