Time Format 0000 to 2400

[Lloyd Peck]

Is there any way I can get Excel and VBA to show midnight, 0000hrs as
2400hrs??

Lloyd

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[David McRitchie]

Hi Lloyd,

format, cells, custom
0000; -0000; 2400

0000"hrs"; -0000"hrs"; 2400"hrs"