Need formula to calculate time in hours between two date ranges

Originally Posted by Roger Govier

Hi Anil

I have changed the entries on my workbook to match yours, and I still believe that your calculation is incorrect.

take example 1
The only effective time is from 10:00 to 18:30 which is 8:30 hours

In example 2
On day 1 the time is from 14:30 to 20:00 which is 5:30 hours
On day 2 it is from 10:00 to 19:00 which is 9:00 hours
giving a total of 14:30 hours

Hi Roger,

Yes you are correct, now its working for me.. thank you much...