Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subtracting times
Message
From
30/10/2003 06:42:13
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00844412
Message ID:
00844446
Views:
50
One line function with time rotation:
Firsttime = '18:00:00'

Chk1time = '08:03:45'
? GetTimeDiff(Firsttime,Chk1time)

PROCEDURE GetTimeDiff ( time1,time2 )

RETURN STUFF(STUFF(RIGHT(TTOC({^1900/01/01 00:00} + (EVALUATE('{^1900/01/01 '+m.time2+'}')-EVALUATE('{^1900/01/01 '+m.time1+'}'))%86400,1),6),5,0,':'),3,0,':')

ENDPROC
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform