Date and Time import from google sheets

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!

I got help from Airtable - here is the format:

ID, Date
1, 2020-03-04T10:20:00.000
2, 2020-02-01T20:15:00.000
3, 2020-04-30T01:00:00.000

I did a join formula in google using ‘T’ as the delimiter.

image

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.