Format a cell so it automatically adds PM after the time

[Xcythe]

I’m trying creating a time sheet for work. I add in the time and it calculates my hours based on the start and finish time.

I want to use 12 hour time as opposed to 24 hour, but I always have to enter the finish time in 24 hours or it will change to AM. Is there a way around this? Removing the AM in the format code results in the time being “12:00 P5”.

Thank you in advance.

[irongron]

Well there is a way around it. Just type in the finish time with PM after it. So 05:00PM rather than 17:00 for example or just type in 04:00PM rather that 16:00 but it means more keystrokes. Remember, there is no way for the spreadsheet logic to distinguish between 12 hour time without the AM or PM added manually as typing in 09:00 means 09:00AM not 09:00PM which is 21:00.