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?
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.
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!
Depending on how Start and End are formatted (Datetime, Date & Time), I’ve come with various possibilities for this
@Jean_Pierre_Traets : You’ll even find how to get from 18:30 to 6:30 PM .
I’ve also run into the problem of Minute() showing only one digit when Minute()=0
EDIT 2019-09-23T16:20:00Z : I forgot something : This is the correct formula (for other possibilities, see the doc below )
This is the formula of the blue result in the doc Concatenate(MonthName([Start Date/Time],"MMM")," ",[Start Date/Time].Day(),", ",If(ToTime([Start Date/Time])<ToTime("12:00PM"),[Start Date/Time].Hour(),[Start Date/Time].Hour()-12),":",If([Start Date/Time].Minute()="0","00",[Start Date/Time].Minute()),"-",If(ToTime([End Date/Time])<ToTime("12:00PM"),[End Date/Time].Hour(),[End Date/Time].Hour()-12),":",If([End Date/Time].Minute()="0","00",[End Date/Time].Minute()),[End AM/PM])