If you enter 4/10, Excel converts that fraction to a date. Reply JSG says: 2021-04-29 at 10:08 pm hello, how to change the time format using an excel function, example, converting this format (12:00 AM/PM) to (12-00-00 AM/PM), (12:00:00 AM/PM), (12 AM/PM) thanks ...