topic Re: Calculate Time after 24 hours in Application Development and Automation Discussions

Calculate Time after 24 hours

Former Member — Fri, 22 Aug 2008 07:07:29 GMT

Hi,

In one of my report I need to calculate the total working hours for a group of employees in a particular week.

in this we have requirement to sort the hours like total ordinary hours,one and half pay hours and double pay hours.

My issue is I want to add the total hours for two timings.

For Example 30:00:00( time 1)

25:30:00(time 2)

The total hours should show as 55.30.00 but as the time is only 24:00:00 after 24

it starts with 00:00:00 and shows the output as 07:30:00

i found a function module 'SD_CALC_DURATION_FROM_DATETIME' to count after 24 hours but this did not help me as this is using date.

in my logic we first check for each day so working hours will never be over 24 hours but after

processing all records in a loop we need to sum up the hours.

could any one please suggest me a solution to count after 24 hours.

Thanks in advance

Cheers,

Rayudu

Re: Calculate Time after 24 hours

Former Member — Fri, 22 Aug 2008 07:24:25 GMT

Hope this FM can help

SD_DATETIME_DIFFERENCE

Regards,

Prashant

Re: Calculate Time after 24 hours

Former Member — Fri, 22 Aug 2008 07:30:18 GMT

hey i have similar code,

just excute it.

data: a type sy-uzeit,

b type sy-uzeit, c(2),d(2),e(2),f(2),g(8),h(2).

a = sy-uzeit.

b = sy-uzeit.

c = a+0(2) + B+0(2).

d = a+2(2) + b+2(2).

e = a+4(2) + b+4(2).

if e > 60.

h = e / 60.

e = e mod 60.

d = d + h.

endif.

if d > 60.

f = d / 60.

d = d mod 60.

c = c + f.

endif.

CONCATENATE c ':' d ':' e into g.

write:/ a,/ b,/ c,/ d, / e.

write:/ 'time is',g.

*if u dont get the code.use debuger'or reply me back

Re: Calculate Time after 24 hours

Former Member — Fri, 22 Aug 2008 07:34:00 GMT

Hello


DATA: T1 TYPE T,
      T2 TYPE T,
      TSUM LIKE TVRO-FAHZTD.
FIELD-SYMBOLS: <H>, <M>, <S>.

T1 = '801000'.
T2 = '303000'.

ASSIGN T1+0(2) TO <H>.
ASSIGN T1+2(2) TO <M>.
ASSIGN T1+4(2) TO <S>.
TSUM = TSUM + ( <H> * 10000 ) + ( <M> * 100 ) + <S>.

ASSIGN T2+0(2) TO <H>.
ASSIGN T2+2(2) TO <M>.
ASSIGN T2+4(2) TO <S>.
TSUM = TSUM + ( <H> * 10000 ) + ( <M> * 100 ) + <S>.

WRITE TSUM.

In this example time1 = 80:10:00 and time2 = 30:30:00

Result is 110:40

Re: Calculate Time after 24 hours

Former Member — Fri, 22 Aug 2008 08:03:13 GMT

Hi,

your table will have the time field and the select statement

will take all the records in to the table right.

after that:

loop at the table and use the COLLECT command that will automatically sum up the numeric values that are in your table:

This statement inserts the contents of a work area wa either as single row into an internal table itab or adds the values of its numeric components to the corresponding values of existing rows with the same key.

Hope this helps

thanks,

Rashmi