Problems trying to Paste into "Date" field that "Includes time"

[M_L]

I'm attempting to paste Date and Time information into an Airtable "Date" field which has the "Include time" option checked. But, when I paste Date and Time information, it all goes in the "Date" part of the cell, and none of the text goes into the "Time" part of the cell.

For example, I'm trying to paste "11/21/2024 10:00 AM" into the Date and Time cell, but it puts all of this text under the "Date" portion, keeps the cursor in the "Date" portion, and enters the current time (i.e., 2:13 PM) in the "Time" portion of the cell, lol.

How can I accomplish this basic copy-and-paste operation with Airtable's Date-and-Time formatted column so the Date goes in the Date, and the Time goes in the Time?

For those unfamiliar, Airtable's "Date" field with "Include time" checked creates a cell with seemingly two cells within it, as shown in the screenshot below.

Finally - I have all my data in a Google Sheets spreadsheet, which I could easily copy-and-paste into the Airtable table. BUT, right now I am having to manually enter all of the Spreadsheet text because of the glitches that surface when I try to paste into Airtable.

Airtable Settings for the "Date" field that has "Include time" checked:

This is how the cell looks when I try to paste basic Date and Time text like "11/21/2024 10:00 AM"

TIA for your help!

ML

[TheTimeSavingCo]

Try creating a formula field to convert your text into a date, and then paste that into the Date field:

DATETIME_PARSE(
  {Text to paste},
  'MM/DD/YYYY hh:mm A'
)