Break Apart Calendar Event Date/Time

So I’ve connected a Google Calendar to my doc and it pulls everything across I need. However, I don’t like the way it shows on the phone so I’m looking to see how I can improve this. What happens now is it shows the appointment like this:

You can see the date and time all bunched together. What I would like it to show is :

Sep 17, 6:30-8:00PM

Is that possible? My thought would be to break up the start date/time and end date/time, and then build it back together in a new column? Or am I overthinking it?

Hi @Chad_Oglesbay,

Will you be able to share a dummy copy of your doc, where at least the above is available.
Formulas is not my strongest point, but I will try to give it a chance, otherwise for sure there will be somebody in the community to support on this.

When I see people doing this, I get inspired:

Hello, here is a copy of my doc with the calendar: Pack Calendar Doc Your example above is really cool! I would love to be able to make mine like that!

Credits to @Rohan_M

For your kind reference;

Dear Chad,

)* Not clear to me why I get only one digit minutes

)** Not clear to me how to change between 18 and 06 - AM / PM

Hopeful it give some inspiration and I am sure there are more elegant ways, hopeful we get more input from the community