Hello in my Time Sheet workbook there are cell values as:

2/13/2018 1:28:01 PM in the formula bar

Even though I set the format for Time (1:30 PM) as the choice in drop down.

It appears as 1:28 PM

I would prefer that in any occurrences of time they be 1:28 PM in the cell and in the formula bar.

Is there any way to ensure this happens ? I am trying to understand why they are different.

Thank you,
Billy