How do I convert military hour to standard Central time hour

[Anonymous]

I extracted the hour from my date field, however, the hour shows as military time.  I am having trouble using the FORMAT to format for standard time.   This is my new column. 
Hour = HOUR([p_datetime]

This is my table.  I would like for the hour to show 6 for 18, etc.  

[VahidDM]

Hi   

Check these posts:
https://community.fabric.microsoft.com/t5/Desktop/Seperate-Time-from-Date/m-p/308981

https://community.fabric.microsoft.com/t5/Desktop/Get-Time-from-DateTime-field/td-p/2572372

Or use TIME function: https://learn.microsoft.com/en-us/dax/time-function-dax

TIME(HOUR([p_datetime]),MINUTE([p_datetime]),SECOND([p_datetime]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

@Anonymous

[jdbuchanan71 · Accepted solution]

You could try it like this.

Hour = FORMAT('Table'[p_datetime],"h AM/PM")