topic Re: Regarding difference between time, date in Application Development and Automation Discussions

Regarding difference between time, date

Former Member — Mon, 27 Aug 2007 06:59:35 GMT

HI Frnds,

I have a start time end time , and start date & end date I want to calculate difference in Hours, can anyone give Function Module or simple logic for this,

Thanks,

Y.Ravi kumar

Re: Regarding difference between time, date

Former Member — Mon, 27 Aug 2007 07:05:31 GMT

hi,

for diff between dates..

use : HR_HK_DIFF_BT_2_DATES

case1 :

Input :

DATE1 01.06.2007

DATE2 01.05.2001

OUTPUT_FORMAT 03

Export parameters Value

YEARS 6.0000

MONTHS 0.0000

DAYS 32

case2 :

Input :

DATE1 01.06.2007

DATE2 01.05.2001

OUTPUT_FORMAT 02

Export parameters Value

YEARS 0.0000

MONTHS 0.0000

DAYS 2,223

then multiply days with (24 * 60 )

With Rgds,

S.Barani

Message was edited by:

S BHARANIDARAN

Re: Regarding difference between time, date

Former Member — Mon, 27 Aug 2007 07:20:29 GMT

*Consider the code below, it gives No. of hours

REPORT ZTRIP_TEST.

parameters:

stime like sy-uzeit,

etime like sy-uzeit,

sdate like sy-datum,

edate like sy-datum.

data:

diff type t,

hours type i.

initialization.

stime = '230000'.

sdate = '20070827'.

etime = sy-uzeit.

edate = sy-datum.

start-of-selection.

diff = etime - stime.

hours = ( edate - sdate ) * 24 + diff+0(2).

write: 'Hours = ',hours.

Reward points if useful, get back in case of query...

Cheers!!!

Re: Regarding difference between time, date

Former Member — Mon, 27 Aug 2007 07:22:41 GMT

HI,

use this fn mod : /SDF/CMO_DATETIME_DIFFERENCE

Import parameters Value

DATE1 01.06.2003

TIME1 11:01:36

DATE2 27.08.2007

TIME2 13:00:00

Export parameters Value

DATEDIFF 1,548

TIMEDIFF 2

EARLIEST 1

tot time =datediff * 24 * 60 +

timedif * 60.

reply back

With Rgds,

S.Barani