This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here are screen shots of what I have. I'm not sure where I'd provide your function. I tried it with [Received 2],but [Received 2] was null. I only tried using the part of the function that is associated with the time, "%I:%M: %p" I'm assuming that first alpha is "I" as in Indigo? I set up the formula like this: DateTimeParse([Received 2],"%I:%M: %p")
Touching again on this subject, here is a sample of how to parse date time coming in 12 hour format with the AM/PM specifier; please note that when the specifier is on PM, it adds 12 hours to the parsed date time.
I guess that the key to it is to use the %I and %P specifiers on the format side of the formula's parameters.