Military time to standard time

[ShawnG2G2]

I am curious if anyone knows how to solve this issue? Both columns are set to Text. 

[PaulDBrown · Accepted solution]

Judging by the error message, I would say the military time column is a number type, so you need to exclude the ".." from the comparison expressions: 

ie IF('Transactions By Hour[Military Time] =  0, "12:00 AM", .....

Btw I suggest you use the SWITCH function for this:

Standard Time =
SWITCH(TRUE(), 

Transactions By Hour[Military Time] =

0, "12:00 AM",

Transactions By Hour[Military Time] < 12, Transactions By Hour[Military Time]  & ":00 AM",

Transactions By Hour[Military Time] =12, "12:00 PM",

Transactions By Hour[Military Time] > 12, Transactions By Hour[Military Time] -12 & ":00 PM")

[PaulDBrown · Accepted solution]

Judging by the error message, I would say the military time column is a number type, so you need to exclude the ".." from the comparison expressions: 

ie IF('Transactions By Hour[Military Time] =  0, "12:00 AM", .....

Btw I suggest you use the SWITCH function for this:

Standard Time =
SWITCH(TRUE(), 

Transactions By Hour[Military Time] =

0, "12:00 AM",

Transactions By Hour[Military Time] < 12, Transactions By Hour[Military Time]  & ":00 AM",

Transactions By Hour[Military Time] =12, "12:00 PM",

Transactions By Hour[Military Time] > 12, Transactions By Hour[Military Time] -12 & ":00 PM")

[PaulDBrown · Accepted solution]

@ShawnG2G2 

Actually there is a much simpler way (now that I have access to a computer instead of my phone!).

Use the following code for the calculated column:

Standard Time = 
FORMAT(TIME('Transactions By Hour'[Military Hour], 00, 00), "HH:MM AM/PM")