Adding Datetime Format

[VentureOutInc]

I have a formula in the primary field of my table that combines a Date/time and the name of the brand in the appointment.  Formula I am using:

DATETIME_FORMAT({Appointment Time},'MM/DD, H:MM A')&" - "&Brand

results are randomly adding 2, 4 and 6 minutes to the time format, ex:

04/09, 9:04 AM - Gregory

(appointment time is 9:00 am in the calendar column)

I'm lost, what am I not specifying that would prevent this?

Thanks!

[TheTimeSavingCo · Accepted solution]

Ah, you want to use "mm", not "MM".  "MM" returns the the month of the year, while "mm" returns minutes:

Here's a link to the date format specifiers too: https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format

[VentureOutInc]

That solved it, thank you!  appreciate you taking the time to help -