topic Converting Time format to Decimal Value in Application Development and Automation Discussions

Converting Time format to Decimal Value

Former Member — Fri, 31 Oct 2008 10:26:37 GMT

Dear All,

How to convert time to decimal value for substraction of time and decimal value

for eg l_time type tims

l_dec type p.

l_diff = l_time - l_dec

Kindly let me know.

Thanks in Advacne,

Ranjan

Re: Converting Time format to Decimal Value

Former Member — Fri, 31 Oct 2008 10:50:32 GMT

Hi,

Try like this...


 PARAMETERS : tim TYPE tims,
             y TYPE p.
DATA : t TYPE string,
       t1 TYPE string,
       t2 TYPE string,
       t3 TYPE string.

START-OF-SELECTION.

  t = tim(2).
  t  = t * 3600. " hours to second
  t1 = tim+2(2).
  t1 = t1 * 60.  " minutes to second
  t2 = tim+4(2).
  t3 = t + t1 + t2. " total time in second
  t3 = t3 - y.

Regards

Debarshi

Re: Converting Time format to Decimal Value

Former Member — Fri, 31 Oct 2008 11:03:38 GMT

Hi,

Hope the following Threads will help you regarding your problem.

This thread is really very helpful.

Thanks.

Nitesh