On reflection, the solution to my question seems clear ...
str2time endtime, generate(fendtime)
str2time begintime, generate(fbegintime)
generate elapsehrs = ((enddate - begindate)+(fendtime - fbegintime))*24
Dale Steele wrote:
> I need to calculate the elapsed time in hours between two events, each
> specified by a date variable and a string "hh:mm" where hh is 0 to 23
> and mm is 0 to 59. For example...
>
>
> begindate begintime enddate endtime
> ---------------------------------------------
> 07jul2004 22:30 09jul2004 12:30
>
> I found the str2time command which converts a string variable containing
> times in this 24 hour clock format (HH:MM or HH:MM:SS) into an elapsed
> time format (a numeric value between 0 and 1) available at:
>
> http://www.sealedenvelope.com/stata_tim.php
>
> -->
> str2time begintime, generate(fbegintime)
>
> begintime(string) fbegintime
> 03:17 .13680556
> 15:26 .64305556
>
> I'm struggling with the stata code to format each date as elapsed days
> since 01jan1960, convert into a real number, add the fractional part,
> then subtract to find elapsed time in days.
>
> Thanks!
>
> Dale
>
>
>
>
>
>
>
> Douglas Crawford wrote:
>
>
>>Hi,
>>
>>The egenmore manual suggests that I can format the result of dhms:
>>
>>dhms(d h m s) [ , format(format) ]
>>
>>but the %t formats available do not seem to permit units smaller than a day
>>(with an emphasis on larger units such as quarter). Ideally I would like to
>>display any of the following:
>>
>> date:hh:mm
>> d:hh:mm
>> hh:mm
>> hh:mm:ss
>>
>>I don't want to generate a string, just display the results of dhms in an
>>attractive a manner as the date formats. The list archive suggests that
>>this is a wish-list item, but I am hoping I missed something.
>>
>>Thanks, as always, for your help.
>>
>>Cheers,
>>
>>Douglas
>>
>>
>>
>>
>>*
>>* For searches and help try:
>>* http://www.stata.com/support/faqs/res/findit.html
>>* http://www.stata.com/support/statalist/faq
>>* http://www.ats.ucla.edu/stat/stata/
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
