Excel - changing dates from AM to PM

  • Thread starter Thread starter mil4567
  • Start date Start date
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
 
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
 
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
 
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!
 
Back
Top