topic Re: Duration Math in Application Development and Automation Discussions

Duration Math

sap_cohort — Wed, 20 Sep 2006 14:19:58 GMT

Hi, I am having users maintain a time threshold limit in a time field. HH:MM:SS. So for 1 hour 10 minutes they would enter 011000. Now, I have 2 time stamps and I need to know if the timestamp difference is greater than the threshold value of 1 hour and 10 minutes. Not sure the best way to do this. Note: For some reason when I output my time field of 011000 it shows up as 03:03:20?

Should I not have them maintain the threshold as HHMMSS?

Thanks for any help!

Re: Duration Math

Former Member — Wed, 20 Sep 2006 14:23:21 GMT

It outputs 03:03:20 due to the fact that it considers it to be 11000 seconds...if you wish to output it just

WRITE lthreshold using edit mask '__:__:__'.

As for calculation, when you calculate the difference between the two time stamps the output might be in seconds and in that case you would need to convert the above to seconds and compare.

Re: Duration Math

sap_cohort — Wed, 20 Sep 2006 15:46:29 GMT

Hi, not sure I understand this well enough. Can you explain what the difference between the following is?

The Write Statement outputs them differently.

TIME1 = '011000'.

TIME2 = 011000.

Thanks!

Re: Duration Math

Former Member — Wed, 20 Sep 2006 15:59:01 GMT

Basically in case of TIME2 it is considered to be 11000 seconds and hence it manipulates it to 03:03:02...but in the other case it is a character string and is interpreted as HHMMSS.

Re: Duration Math

Former Member — Wed, 20 Sep 2006 16:23:49 GMT

Hi,

Output depends upon user default setting for time

check usr01 table or

system-user profiles-default data.

to overide default settings we have use

write time using edit mask '::--'

Regards

Amole

Re: Duration Math

sap_cohort — Thu, 14 Dec 2006 14:40:36 GMT

Question Answered