HELP || How to convert 20:00 into this format (8:00:00 PM)

**mitmike2001** · 11-05-2012, 05:34 PM

Please help me in converting a certain data into this format (8:00:00 PM)

Eg. 20:00 to 8:00:00 PM

I can do this by highlighting the cell and pressing F2. But i have tons of data to convert so i really your help in finding a formula to covert it.

**K m** · 11-05-2012, 05:45 PM

Highlight the cells and change the cell format to Time

FORMAT/CELL/TIME

**mitmike2001** · 11-05-2012, 05:55 PM

Sorry there was a confusion in my part.

I need to convert 20:00 to 08:00:00 PM.
The cell shows 20:00 and when i highlight it, it shows 20:00
I need to convert that certain data(20:00) that will show when highlighted to be 08:00:00 PM

Please help me on this one.