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