Excel - changing dates from AM to PM

M

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
 
L

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
 
A

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
 
Top