07-25-2013 9:08 AM
Hi,
I am using this FM CRM_ORDER_READ_OW in CRM to get the start and end time of a request.
Format - DD.MM.YY HH.MM.SS
Start time = 19.11.2012 18:09:33 CET
End time = 26.11.2012 18:09:33
Can you please guide on how can I calculate the duration in HOURS between these 2 timestamps?
Thank you very much!
Kind regards,
Rebekah
07-25-2013 9:14 AM
07-25-2013 9:12 AM
07-25-2013 9:14 AM
07-25-2013 9:16 AM
07-25-2013 9:30 AM
07-25-2013 9:36 AM
Sunil,
I am not sure about that.
If it is not there, refer the link mentioned by Satyabrata Sahoo.
Regards.
07-25-2013 9:49 AM
07-25-2013 10:04 AM
Hi,
Use this FM CCU_TIMESTAMP_DIFFERENCE or OII_CALC_DIFF_BT_TIMESTAMPS
or try like this way to find FM in se37
07-25-2013 9:23 AM
Hi,
Check FM 'CCU_TIMESTAMP_DIFFERENCE' You will get the result in sec, divided by 3600 you will get the result in hours, pass the input values as YYYYMMDDHHMMSS.
Thanks
Ravi
07-25-2013 9:56 AM
Hi
Use the following FM: CCU_TIMESTAMP_DIFFERENCE
Provide inputs as DDMMYYYYHHMMSS format
The output would be in Seconds.
Divide by 60 to get in minutes
In the above, I give example as today 09 am to 11:00 am
It gives 7200 seconds, that is 120 minutes that is 2 hours
Regards
Venkat
07-25-2013 9:58 AM
07-25-2013 10:09 AM
Hi Rebekah,
Try this function module /SDF/CMO_DATETIME_DIFFERENCE
Thanks & Regards,
-VIJAY
07-25-2013 10:15 AM
Hi,
Use the FM 'DELTA_TIME_DAY_HOUR' which will give you the diffence in minutes
divide the minutes by 60 to get the answer in hours.
10080/60 = 168 hours
Regards,
Jayashree
07-25-2013 10:16 AM
Hi Rebekah,
FM IGN_TIMESTAMP_DIFFERENCE will give you the result rounded in hours, when import parameter I_UNIT is set to 'H'.
Regards,
Klaus
07-25-2013 10:29 AM
Hi Rekebeh,
U can use this FM.
CALL FUNCTION 'LTRM_TIME_GAP_CALC' "Calculate time difference between two time stamps
EXPORTING
i_locat = " lloct-locat Site
timestamp1 = " ccupeaka-timestamp Timestamp im Format "JJJJMMTTHHMMSS"
IMPORTING
difference = " i Difference TimeS1 - TimeS2
. " LTRM_TIME_GAP_CALC.