Google Calendar All Day Event. I could then drag and drop it into a time. You want to know the reason of the error message of invalid format:
Try removing the all day event and description columns and putting a space between the time and am/pm. I could then drag and drop it into a time.