<div dir="ltr">Brian, I think you might be able to do what you want if you convert your files to ELAN. The chat2elan command will do this for you (I did yours - see attached). When you open your file in ELAN it will ask to locate the media file. You can click cancel. Then when your file opens, look under the Grid tab, select tim@PAR and see if what is gives you is what you're after. If so, you can export that to Excel and work from there. I mostly work with CHAT files but do this occasionally for certain analyses. <div><br></div><div>Good luck,</div><div>Nicole</div><div><br></div><div><br></div><div><br></div><div><p class="MsoNormal">Nicole Tracy-Ventura</p><p class="MsoNormal">Assistant Professor</p>
<p class="MsoNormal">Department of World
Languages</p>
<p class="MsoNormal">University of South
Florida</p>
<p class="MsoNormal">4202 East Fowler Ave,
CPR419</p>
<p class="MsoNormal">Tampa, FL 33620-5700</p>
<p class="MsoNormal">Email: <a href="mailto:nkt@usf.edu">nkt@usf.edu</a></p>
<p class="MsoNormal"> </p></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Feb 3, 2016 at 3:35 PM, Brian Verdine <span dir="ltr"><<a href="mailto:brian.verdine@gmail.com" target="_blank">brian.verdine@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks Brian! This is not that different from the reply I thought I might be in for...<div><br></div><div>I am sure I can get some output from something like KWAL that can make the calculation easier than having to open each and hand calculate, but at least now I know there is nothing built-in that I am missing or that I'm not doing something wrong with headers or tiers.</div><div><br></div><div><span class=""><br><br>On Wednesday, February 3, 2016 at 3:24:10 PM UTC-5, Brian MacWhinney wrote:</span><blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif"><span class="">
<div>
<div>
<div>Dear Brian,</div>
<div> Unfortunately, none of the CLAN programs use the information in the %tim tier to computer anything. Instead, as the manual notes, the TIMEDUR program specifically relies on information in the time bullets for each utterance. I am afraid I can’t think
of any work around to help you out on this. The closest I could imagine is to use KWAL to output all of the %tim lines from each file separately to a single data file that then goes into a sheet in EXCEL or something like that. However, I can’t think of
any way of doing this inside CLAN, because our programs are dependent on using information in the time bullets.</div>
<div><br>
</div>
<div>—Brian MacWhinney</div>
<div>
<div></div>
</div>
</div>
</div>
<div><br>
</div>
</span><span>
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>ChiBolts <<a rel="nofollow">chib...@googlegroups.com</a>> on behalf of Brian Verdine <<a rel="nofollow">brian....@gmail.com</a>><br>
<span style="font-weight:bold">Reply-To: </span>ChiBolts <<a rel="nofollow">chib...@googlegroups.com</a>><span class=""><br>
<span style="font-weight:bold">Date: </span>Wednesday, February 3, 2016 at 12:35 PM<br>
</span><span style="font-weight:bold">To: </span>ChiBolts <<a rel="nofollow">chib...@googlegroups.com</a>><span class=""><br>
<span style="font-weight:bold">Subject: </span>Timedur, %tim, and getting elapsed time output<br>
</span></div>
<div><br>
</div>
<blockquote style="BORDER-LEFT:#b5c4df 5 solid;PADDING:0 0 0 5;MARGIN:0 0 0 5">
<div>
<div><span class="">
<div dir="ltr">Hi everyone,
<div><br>
</div>
<div>I'm a new user and I have been doing some work to convert a homegrown transcription system to CHAT files. The transcriptions I converted all had a start time that was the timestamp from the videos and every X utterances, transcribers were asked to write
another timestamp, including specifically stamping the last utterance. I did not want to lose this information, so when I created the CHAT files I used a VB script to put the start time in with an "@Time Start: mm:ss" header and then placed all of the following
timestamps into the transcriptions with %tim tiers, resulting in a file that looks like the attached. Because these transcriptions are converted from another format, they are not linked in any way to the video using bullets.</div>
<div><br>
</div>
<div>I'm having a hard time finding a lot of information about getting commands to read time information written into the transcriptions or if there is a simple way to just output the total elapsed time for a transcription from the start time and %tim tiers.
From what I gather timedur does not look at %tim tiers and I can verify that when I run it on these files it outputs a blank excel sheet with timedur column headers. </div>
<div><br>
</div>
<div>I am not necessarily looking to do anything fancy. I want to be able to auto-calculate the total time for identifying possible reliability concerns, report average transcribed times in a methods section, and
<i>maybe</i> be able to do some basic rate calculations in CLAN based on total time. </div>
<div><br>
</div>
<div>Is there a command I'm missing? Is there a different format, headers, or tiers I would need to use? Or is there a way I can simply get the program to output the start time and the last %tim tier for a group of files to an excel sheet so that I can calculate
the elapsed times quickly as a batch? I <i>could</i> have people go through them individually and make changes or just calculate the times, but it is about 120 transcriptions. I figured some time investigating ways to automate this might be worth it.</div>
<div><br>
</div>
<div>Thanks for any help!</div>
<div>Brian<br>
<br>
</div>
</div>
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br></span>
To unsubscribe from this group and stop receiving emails from it, send an email to
<a rel="nofollow">chibolts+u...@googlegroups.com</a>.<br>
To post to this group, send email to <a rel="nofollow">chib...@googlegroups.com</a>.<span class=""><br>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/fbef00d1-7f17-4c50-8840-b4eb23ca3a6a%40googlegroups.com?utm_medium=email&utm_source=footer" rel="nofollow" target="_blank">
https://groups.google.com/d/msgid/chibolts/fbef00d1-7f17-4c50-8840-b4eb23ca3a6a%40googlegroups.com</a>.<br>
For more options, visit <a href="https://groups.google.com/d/optout" rel="nofollow" target="_blank">https://groups.google.com/d/optout</a>.<br>
</span></div>
</div>
</blockquote>
</span>
</div>
</blockquote></div></div><span class="">
<p></p>
-- <br>
You received this message because you are subscribed to the Google Groups "chibolts" group.<br>
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:chibolts+unsubscribe@googlegroups.com" target="_blank">chibolts+unsubscribe@googlegroups.com</a>.<br>
To post to this group, send email to <a href="mailto:chibolts@googlegroups.com" target="_blank">chibolts@googlegroups.com</a>.<br></span>
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/c5c100bc-8a3e-4743-9344-ab04a1769924%40googlegroups.com?utm_medium=email&utm_source=footer" target="_blank">https://groups.google.com/d/msgid/chibolts/c5c100bc-8a3e-4743-9344-ab04a1769924%40googlegroups.com</a>.<div class="HOEnZb"><div class="h5"><br>
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank">https://groups.google.com/d/optout</a>.<br>
</div></div></blockquote></div><br></div>
<p></p>
-- <br />
You received this message because you are subscribed to the Google Groups "chibolts" group.<br />
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="mailto:chibolts+unsubscribe@googlegroups.com">chibolts+unsubscribe@googlegroups.com</a>.<br />
To post to this group, send email to <a href="mailto:chibolts@googlegroups.com">chibolts@googlegroups.com</a>.<br />
To view this discussion on the web visit <a href="https://groups.google.com/d/msgid/chibolts/CA%2B3CKJ76pen-y-ed5e_%3DMhrg3womNypq4Ow2UzJauXaxSt8r1A%40mail.gmail.com?utm_medium=email&utm_source=footer">https://groups.google.com/d/msgid/chibolts/CA%2B3CKJ76pen-y-ed5e_%3DMhrg3womNypq4Ow2UzJauXaxSt8r1A%40mail.gmail.com</a>.<br />
For more options, visit <a href="https://groups.google.com/d/optout">https://groups.google.com/d/optout</a>.<br />