Calculate date time difference between two dates

[#1]

Hello Friends,

I want to calculate date time difference between two dates.

For Example.

From date: 20/05/2012 15:30:00

To date: 22/05/2012 10:00:00

Need to calculate only this time --> 08:00 - 18:00

So according to above time

difference is:

2:30 Hours on 20/05/2012

10:00 Hours on 21/05/2012

2:00 Hours on 22/05/2012

Total Time Difference: 14:30 Hours

Can you please help me how to solve this?

Thanks

[Gysbert_Wassenaar · Accepted solution]

See here or here