Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Differences between two time expresions
Message
 
 
To
12/09/2002 11:36:34
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00699743
Message ID:
00699802
Views:
17
Try
lcTime2 = '09:25:16'
lcTime1 = '09:02:45'
lnSeconds = CTOT(lcTime2) - CTOT(lcTime1)
? TRANSFORM(RIGHT(TTOC( DTOT(DATE()) + lnSeconds,1),6), "@R 99:99:99")
It will work as long as lnSeconds < 86400. If lnSeconds >= 86400 see Re: Datetime variation in HH:MM:SS Message #698240.

>What I want is to substract them and convert that result in minutes\seconds format.
>
>I've tried this (CTOT('09:25:16') - CTOT('09:02:45'))/60) but in the most cases the result is a fraction that I don´t know hopw to convert to seconds.
>
>Any idea?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform