Excel - changing dates from AM to PM

[mil4567]

Hi all, I need to know how to convert times from AM to PM, for example:
9:53 AM
10:33 AM
10:50 AM

change to:
21:53 PM
22:33 PM
22:50 PM

(obviously I need to change a number of records at once!)

Any help would be greatly appreciated!

Thank you
Mar

 

[Llobid]

Mil...

Try this.

Highlight the column that contains the times (provided that is all tha
is in the column). Then go to Edit...Replace. First replace all of you
PM with your initials...that is if you are also going to change PM t
AM eventually.

Next, go to Edit...Replace and replace all of your AM to PM.

Finally, replace your initials with AM (if you are wanting to conver
PM to AM).

Then highlight the column and go to Format...Cells and select the tim
format that you want

 

[Andy B]

Hi

You need to add 1/2 to each cell. An easy way to do this is to type 0.5 in a
blank unused cell and copy it. Select your range and then Edit / Paste
Special . . . Add

 

[hellebore08]

example cell a1 is equal to "10:00:13 AM"
enter formula in cell b1 "=a1+time(12,0,0)"
cell b1 = 10:00:13 PM..

cheers!