>Text1 has this value
>
>11:25-13:30
>
>I want to get tolal elaspsed time as
>
>02:05
>
>The I want to multiply 02:05 with 5 as
>
>10:25
>
>Please help
or Nadyas reply in short:
lnSec = int(ABS(CTOT('11:25')-CTOT('13:30')))
?TRANSFORM(100*INT(lnsec/3600)+INT((lnsec%3600)/60),'99:99')
lnSec =lnSec *5
?TRANSFORM(100*INT(lnsec/3600)+INT((lnsec%3600)/60),'99:99')
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]