Trying to input time calculation so it does not change to 24 hour format

[moebfd]

Hi All,
I am trying to do a calculation on time but don't want it to convert to 24 hour format.
I have formatted all columns to h:mm
As you can see from the picture below, when I enter the 12:55 it shows as 13:00 (the result). When I enter 1:00 it shows as 1:05 which is what I want to show.
The first column is what I input and the second column is where it does the calculation (a1+5/1440) to add on 5 minutes to the time.
How to do I get the 13:00 to show as 1:00.
Can anyone help please?
Thanking you in advance.
Kind regards

 

[Sergius]

Hello! Set this format for your cells h:mm AM/PM

12:55 PM	1:00 PM
1:00 AM	1:05 AM

 

[moebfd]

Thank you for the quick reply.
Is there a way of showing it without the "AM" or "PM" so it only displays "1:00" and "1:05"

 

[Peter_SSs]

Duplicate to: Time without "AM" or "PM"

Welcome to the MrExcel board!

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.