VBA to convert 12 hour to 24 hour time

**Krrattner** · 05-17-2005, 05:33 PM

I've got a large spreadsheet that displays time in " 0130P" format and need to convert that to military time so that it reads "13:30". Is there and easy way or programming function to call this?

Thanks!!!

**mudraker** · 05-17-2005, 07:56 PM

You can use a formula in a blank cell to display the time as required or you can use a macro to change value of the cell to what you require it to show.

Please reply with which option you would prefer to use

**vijay20cbe** · 10-10-2011, 09:06 PM

I would like both. can you give me the solution immediately...

**roamer** · 07-29-2012, 06:37 PM

I have same problem as krrattner.
VBA to convert 12 hour to 24 hour time
I've got a large spreadsheet that displays time in " 0130P" format and need to convert that to military time so that it reads "13:30". Is there and easy way or programming function to call this?

Thanks!!!
Roamer

**protonLeah** · 07-29-2012, 06:57 PM

@roamer,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.