<html><body>
<DIV>The "Time" edit will not allow any number greater then 23 in the Hours slot.</DIV>
<DIV> </DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">-------------- Original message -------------- <BR>From: Jeff Harrison <jeffaharrison@yahoo.com> <BR><BR>> --- Jeff Harrison <JEFFAHARRISON@YAHOO.COM>wrote: <BR>> <BR>> > --- beppler@comcast.net wrote: <BR>> > <BR>> > > Is there an easy way to get an elapsed time using <BR>> > > day & time? <BR>> > > <BR>> > > Filepro v5.0 <BR>> > > <BR>> > > ie: 05/12/06 01:30:45 & 05/14/06 13:26:55 <BR>> > > <BR>> > > I would like elapsed time in form HH:MM:SS <BR>> > > <BR>> > > Thanks <BR>> > > Brandt> <BR>> > _______________________________________________ <BR>> > <BR>> > How about (date2-date1)*"24" < (time2 - time1)? <BR>> > Just <BR>> > make sure that your date fields use a valid system <BR>> > date edit such as mdy/, and your time us
es the <BR>> > "time" <BR>> > edit. <BR>> > <BR>> > Jeff Harrison <BR>> > jeffaharrison@yahoo.com <BR>> > <BR>> <BR>> I guess you wanted one number for the hours though. <BR>> In this case I would put the result of the time <BR>> calculation in a "hms" field, and then use the mid <BR>> function to extract the hours portion add add this to <BR>> the result of your date math * "24", then use mid <BR>> again to extract the minutes and seconds. <BR>> <BR>> Jeff Harrison <BR>> jeffaharrison@yahoo.com <BR>> <BR>> Author of JHExport and JHImport. The easiest and <BR>> fastest ways to generate code for filePro exports and imports. <BR>> <BR>> __________________________________________________ <BR>> Do You Yahoo!? <BR>> Tired of spam? Yahoo! Mail has the best spam protection around <BR>> http://mail.yahoo.com </BLOCKQUOTE></body></html>