Automatic 24 Hour time format

**excellenthelp** · 12-02-2013, 12:45 PM

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:

Formula:

Please Login or Register  to view this content.

Thanks!

**ragulduy** · 12-02-2013, 12:48 PM

it would be

Please Login or Register  to view this content.

I guess.

**Richard Buttrey** · 12-02-2013, 12:52 PM

Hi,

Untested in your workbook but try

Please Login or Register  to view this content.

**excellenthelp** · 12-02-2013, 01:08 PM

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** · 12-02-2013, 01:15 PM

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.

Automatic 24 Hour time format

LinkBack

Thread Tools

Rate This Thread

Display

Automatic 24 Hour time format

Re: Automatic 24 Hour time format

Re: Automatic 24 Hour time format

Re: Automatic 24 Hour time format

Re: Automatic 24 Hour time format

Thread Information

Users Browsing this Thread

Similar Threads

How do I convert an integer number to a 24-hour hh:mm time format using existing syntax?

24 hour time format help with 00:00 calculation

[SOLVED] How to I convert standard time to Military or 24 hour format?

Convert decimal hour into time format?

[SOLVED] Converting time figures into 24-hour format & sorting them...

Bookmarks

Bookmarks

Posting Permissions