My first post! This community has been very helpful. I’m still fairly new to airtable and hope someone can help with this problem.
I have a Google Sheet with a date field, a start time field, and a stop time field. I want to import it into a table with 2 fields: {date and start time} and {stop time}.
I tried to join fields in google sheets, then upload, but it only uploads the date correctly, and the time is ‘12:00am’. I’ve tried different date/time formats, but that hasn’t worked, and made the problem worse in some cases. For example it only works with the 12 hr format, when I tried 24 hour, neither the date nor time uploaded.
Any help or suggestions would be greatly appreciated!
