Oh, ok~ That's very helpful thanks.
Should it work in Tableau Public? I just tried but the result still show AM PM. :/
Will try Tableau Server once I set it up.
(EDIT: Heard that Public is the same as Server. If that's the case why am I still getting the result while yours is successful?)