How to Calculate midpoint between two times ?

[Former Member]

Hi all,

I need help to find out how to take midpoint of 2 timings.

Actually i am working for daily punches done by any employee.

Hence to find the midpoint of an employees IN & OUT punch

i.e midpoint of 2 different timings so as to determine in which time slot he was present.

Regards,

Sandhya.

[Former Member]

Hi,

Fm L_MC_TIME_DIFFERENCE - is ued to Find the (time) difference between two timings.

Above fm is helpful to u.Otherwise go for second one.

SD_CALC_DURATION_FROM_DATETIME: Find the difference between two date/time and report the difference in hours

[Former Member]

Hi,

Fm L_MC_TIME_DIFFERENCE - is ued to Find the (time) difference between two timings.

Above fm is helpful to u.Otherwise go for second one.

SD_CALC_DURATION_FROM_DATETIME: Find the difference between two date/time and report the difference in hours

[Former Member]

hi

<< Moderator message - Cut and paste response from removed. Plagiarism is not allowed in SCN >>

chaitanya

Edited by: Chaitanya.M on Dec 13, 2011 1:37 PM

Edited by: Rob Burbank on Dec 14, 2011 10:25 AM

[Former Member]

You can use the function modules in function group SCA4 to do this.

DURATION_DETERMINE - gives you the duration between the two date/times (get the value back in minutes)

Divide this by 2 to get the duration half way between the start and end times

END_TIME_DETERMINE - to determine the data and time at the halfway point, using the start date and the calculated duration from above.