Need formula to calculate time in hours between two date ranges

Originally Posted by Roger Govier

Hi

Does the attached workbook do what you want?

I don't make the results the same as you show however, as the first line results in 8:30 hours and the second 18:30 hours

Hi Roger,

Thank you for your response. How ever I dint get the anticipated result. I have added sample workbook that what i am looking for. Can please have a look and help me.

Thank you!!!
Anil.