Also you can Format Cell / custom and type in 0\:00 and OK now if you put in 225 it will display as 2:25
Yes, as do I. That is exactly my problem. How do you make the VALUE of 18:00 hours APPEAR as 6:00?
Hi istril
2 - hide the am/pm part in a second line
You can format the cell with a format this way.´
In the Custom Format write
. h:mmAM/PM
. position the cursor between the h:mm and the AM/PM
. press CTRL-J
Format the cell with wrap text
This format sends the AM/PM part to a second line. By keeping the default row height, this second line is not visible and so it's like you have the format you wanted.
Notice that in this case you still have the time value in the cell, you lost no information.
You can kind of minimize the sense of the extra space by center aligning the cell horizontally... the column will still need to be as wide, but the spacing will not look as bad as when right aligned.When I try option 2, i get #### and wrapping text does not seem to do anything. If I open the width of the cell so there is excessive extra room (2x wider than the cell needs to be), it will display 1:30 as i hope. But no matter what I try, I cannot seem to eliminate this excessive space without the information displaying ####
You can kind of minimize the sense of the extra space by center aligning the cell horizontally... the column will still need to be as wide, but the spacing will not look as bad as when right aligned.
Unfortunately, i am bound by a requirement that PM schedules be bold, which I was hoping to conditionally format PM times to be bold so it would happen automatically. This is also why I need the PM time in the cell although need the letters themselves to be absent for space savings. The other unfortunate requirement i have is to not use a 24 hour clock so the general public can understand it (*facepalm*).
In that case can you not use the auxiliary column, that you hide, like I posted?
You can always update the source (hidden) column, and your schedule will update automatically.