Date Math

beppler at comcast.net beppler at comcast.net
Tue May 16 06:05:50 PDT 2006


Works if end time is greater then or equal to start time.

Does not work if end time is Less then the start time

date1: 05/13/2006¡ time1 12:00:00¡
date2: 05/15/2006¡ time2 12:45:00¡
elapsed time   48.750¡   Works OK!!

date1: 05/13/2006¡ time1 12:00:00¡
date2: 05/15/2006¡ time2 11:00:00¡
elapsed time   71.000¡     Wrong!!

  1  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
@wlf4  ¡ If:                                                                               ¡
       Then: tm(8,time)=4-3                                                          ¡
  2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ¡ If:                                                                                    ¡
       Then: 5=(2-1)*"24"+tm;display                                           ¡




-------------- Original message -------------- 
From: Kenneth Brody <kenbrody at bestweb.net> 

> Quoting beppler (Tue, 16 May 2006 03:36:39 +0000): 
> 
> > Is there an easy way to get an elapsed time using day & time? 
> > 
> > Filepro v5.0 
> > 
> > ie: 05/12/06 01:30:45 & 05/14/06 13:26:55 
> > 
> > I would like elapsed time in form HH:MM:SS 
> 
> I haven't tried this, but what about: 
> 
> Subtract the two dates, multiply by 24, and add to the difference 
> of the two times. 
> 
> -- 
> KenBrody at BestWeb dot net spamtrap: 
> http://www.hvcomputer.com 
> http://www.fileProPlus.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060516/0ce11842/attachment.html


More information about the Filepro-list mailing list