Automatic 24 Hour time format

[excellenthelp]

Hello Excellers,

What is the VBA code to convert a cell into 24-Hour time format that I could add to the sheet's code?

0800 becomes 08:00
1500 becomes 15:00
1815 becomes 18:15
Etc...

This is what I am looking for that is similar to the code below that converts the letters to all Uppercase:

Please Login or Register  to view this content.

Thanks!

[ragulduy]

it would be

Please Login or Register  to view this content.

I guess.

[Richard Buttrey]

Hi,

Untested in your workbook but try

Please Login or Register  to view this content.

[excellenthelp]

The code I posted above is an example of what I used for UpperCase.

However, How may I direct the 24-hour format code to be applied to only a specific cell or two?

[Richard Buttrey]

You asked for something akin to your upper case conversion. That was focused on the Target cell in the sheet change event and you appeared to be suggesting that the time format was also to be applied to target cell which is why I gave you what I did.

Just substitute the Cell Reference for the word Target. i.e.

Please Login or Register  to view this content.