Excel question

[randomint]

I have a table with time values in 24-hour format. How can I convert the values to 12-hour format WITHOUT using AM/PM at the end.

For example i want 15:25 to change to 3:25 but EXCEL always adds AM or PM at the end automatically and it becomes 3:25 PM. Now that is technically right but I DON'T WANT AM/PM at the end. I have even tried the custom formatting like (h):mm to no avail (btw it's square brackets around "h" but I put round because the post will screw up).

Is there even a way????

C'mon all EXCEL experts!

 

[randomint]

Got a workaround. If you type in the cell location and then subtract from it 12:00 AM, then you get the time value without AM or PM.

Example: = D65-TIME(12,0,0) where TIME is of the format TIME(hour,minute,second). So if D65 is 15:25, then you would have 15:25 - 12:00 = 3:25. 😀

 

[KLin]

I think hh:mm would work in the custom formatting. You don't need the parentheses.

 

[randomint]

Nope. That doesn't work. I tried that along with many other formats.

 

[bruceb]

But this Will Work:

Format Cells, Custom, then type in: (h):m (you must use square bracket)

When you enter your Time Numbers you will need to
input the : when you put in the Time

 

[randomint]

But i'm not entering time values. I already have them in a table in 24-hour format and (h):mm does nothing.

 

[bruceb]

I am out of ideas on that one

Try posting your query here: http://www.mrexcel.com/board2/

See if they can be of help .. let us know what you find