Scientific notation

If a value contains scientific notation, how can I flag it? Also, how to format time to AM/PM format. If I have a time 13:00, how do I convert it to 1:00 PM? Thanks!