Ask Your Question

Format a cell so it automatically adds PM after the time

asked 2016-05-29 04:02:19 +0100

Xcythe gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-29 04:25:57 +0100

irongron gravatar image

updated 2016-05-29 04:36:57 +0100

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-29 04:02:19 +0100

Seen: 330 times

Last updated: May 29 '16