Posted to microsoft.public.excel.programming

RG III

external usenet poster

Posts: 65

VBA time conversion

Suppose I have the following string variable:

s = "10:20 PM"

Is there a function that will convert s to military like so?:

s = "2200" ' Now represents military time

-Robert

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time Conversion	Jodi Macy[_2_]	Excel Worksheet Functions	3	January 5th 09 08:33 PM
time conversion	GAIDEN	Excel Worksheet Functions	3	November 17th 08 03:00 AM
Time Conversion	Richard	Excel Discussion (Misc queries)	2	June 15th 07 04:04 PM
time conversion	sup191	Excel Programming	13	June 17th 04 05:28 PM
TIME CONVERSION	Tom	Excel Programming	1	May 25th 04 12:33 PM

All times are GMT +1. The time now is 02:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us