Custom Format for 24 hour time

[Livin404]

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

 

[jasonb75]

I did use a Custom format like hhmm but ended up with zeros.

That is the correct format, if i is not working then it is not a valid time in the cell.

 

[Dave Patton]

a guess

T201810a.xlsm
	B	C	D	E
1	Start	End	Time
2	730	1200	04:30:00	Format as Time
3
1b

Cell Formulas
Range	Formula
D2	D2	=TEXT(C2,"00\:00")+0-TEXT(B2,"00\:00")+0

 

[Livin404]

Hi I just used 0000 at that seemed to work great. It was from Custom Format.

 

[jasonb75]

Hi I just used 0000 at that seemed to work great. It was from Custom Format.

If that is the case then they are numbers, not times. This means that they will be 100 minute hours if you do any calculations using those times.

 

[Livin404]

If that is the case then they are numbers, not times. This means that they will be 100 minute hours if you do any calculations using those times.

That does make since. Fortunately, in my case it is fine. I did not want to use Text format otherwise it would have game be those green triangles in the corner. Thank you for your help.