Help with text box and time

Posted to microsoft.public.excel.programming

D.S.[_3_]

external usenet poster

Posts: 60

Help with text box and time

Thanks Kieran,
that got me on the right track. The following code gave me the result I was looking for
txtTime = Format(Sheets("WRITEFORMDATA").Range("B22").Value, "HH:MM AMPM")

D.S.

"Kieran" wrote in message ...

Try this format option

txtTime = Format(Sheets("WRITEFORMDATA").Range("B22").Value, "HH:m")

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
How do I convert time as text 'mm:ss to time value in Excel	Sholto	Excel Discussion (Misc queries)	5	April 1st 09 05:40 AM
Macro / function text time to 24hr excel time passed midnight fortotaling hr's	Russmaz	Excel Worksheet Functions	2	March 6th 09 04:58 AM
Convert Text Time to Excel Time	[email protected]	Excel Discussion (Misc queries)	5	January 29th 07 04:43 PM
convert time imported as text to time format for calculations	batfish	Excel Worksheet Functions	3	October 27th 05 11:24 PM
Convert Text Time to Time	Jan	Excel Discussion (Misc queries)	1	March 7th 05 06:05 PM

All times are GMT +1. The time now is 05:31 PM.

Menu

About Us