<html><body>
<DIV>Works if end time is greater then or equal to start time.</DIV>
<DIV> </DIV>
<DIV>Does not work if end time is Less then the start time</DIV>
<DIV> </DIV>
<DIV>date1: 05/13/2006 time1 12:00:00<BR>date2: 05/15/2006 time2 12:45:00</DIV>
<DIV>elapsed time 48.750 Works OK!!</DIV>
<DIV> </DIV>
<DIV>date1: 05/13/2006 time1 12:00:00<BR>date2: 05/15/2006 time2 11:00:00</DIV>
<DIV>elapsed time 71.000 Wrong!!</DIV>
<DIV> </DIV>
<DIV> 1 ------- - - - - - - - - - - - - - - - -<BR>@wlf4 If: <BR> Then: tm(8,time)=4-3 &nbs
p; <BR> 2 ------- - - - - - - - - - - - - - - - -<BR> If: <BR> Then: 5=(2-1)*"24"
+tm;display </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">-------------- Original message -------------- <BR>From: Kenneth Brody <kenbrody@bestweb.net> <BR><BR>> Quoting beppler (Tue, 16 May 2006 03:36:39 +0000): <BR>> <BR>> > Is there an easy way to get an elapsed time using 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>> I haven't tried this, but what about: <BR>> <BR>> Subtract the two dates, multiply by 24, and add to the difference <BR>> of the two times. <BR>> <BR>> -- <BR>> KenBrody at BestWeb dot net spamtrap: <G8YMH8UF001@SNEAKEMAIL.COM><BR>> http://www.hvcomputer.com <BR>> http://www.fileProPlus.com </BLOCKQUOTE></body></html>