Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings,
I am trying to use a custom format to show 24 hr time in excel. For example 0325 or 0011. I can use 'text format', but that allows a green triangle to appear in the cell, or even a zip code, but I'm trying to do this right. I did use a Custom format like hhmm but ended up with zeros. I know there is a code in the cell format I can use. I just can't remember it.
Any assistance will be great.
Thank you
I am trying to use a custom format to show 24 hr time in excel. For example 0325 or 0011. I can use 'text format', but that allows a green triangle to appear in the cell, or even a zip code, but I'm trying to do this right. I did use a Custom format like hhmm but ended up with zeros. I know there is a code in the cell format I can use. I just can't remember it.
Any assistance will be great.
Thank you