Difference between two dates and time in hours

[chetan_mishra]

Hi,

I have fields contains start date, start time, end date, end time.

How do I calculate the number of hours since start date, start time and end date, end time

Start date : T_DATE1

Start time : T_TIME1

End Date : T_DATE2

End Time : T_TIME2.

Please help

Moderator Message: Date and Time questions are not allowed in this forum. The reason being they have been asked and answered many times here. Please search for relevant information here.

Edited by: kishan P on Dec 16, 2011 12:02 PM

[chetan_mishra]

Hi,

I have fields contains start date, start time, end date, end time.

How do I calculate the number of hours since start date, start time and end date, end time

Start date : T_DATE1

Start time : T_TIME1

End Date : T_DATE2

End Time : T_TIME2.

Please help

Moderator Message: Date and Time questions are not allowed in this forum. The reason being they have been asked and answered many times here. Please search for relevant information here.

Edited by: kishan P on Dec 16, 2011 12:02 PM

[mithun_shetty4]

SD_CALC_DURATION_FROM_DATETIME

or

SD_DATETIME_DIFFERENCE

[Former Member]

Hi,

Please find the FM - DELTA_TIME_DAY_HOUR,

this will give you the time in minutes, hence you can convert it to hours.

Please note the below links;

Moderator Message: Link-farm removed. Please dont do that again.

Hope you will search SDN next time, before posting.

And too hope that this will help you

Thanks & Regards

Manu S

Edited by: kishan P on Dec 16, 2011 12:03 PM