[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Extracting Time from Excel Sheet

From	[email protected]
To	"[email protected]" <[email protected]>
Subject	st: Extracting Time from Excel Sheet
Date	Mon, 23 Feb 2009 11:37:11 -0800

I want to extract the time from v1
Sep/09/1998 08:42:00 PM
where v1 is
str24  %24s
However, all I can extract is
08:42:00 PM
when using substr.
I would like to extract the hours (eg 8) and PM or AM.
Any suggestions?

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

Follow-Ups:
- st: RE: Extracting Time from Excel Sheet
  - From: "Nick Cox" <[email protected]>
- st: Re: Extracting Time from Excel Sheet
  - From: "Martin Weiss" <[email protected]>
- Re: st: Extracting Time from Excel Sheet
  - From: Phil Schumm <[email protected]>

Prev by Date: Re: st: Re: St: stataweave
Next by Date: RE: st: heteroskedastic multivariate normal regression with ml, convergence problem
Previous by thread: st: Re: St: stataweave
Next by thread: Re: st: Extracting Time from Excel Sheet
Index(es):
- Date
- Thread