Calculate number of hours between two dates - Weekdays only

Hello,

I have been searching for this for a while now. I would like to calculate the difference between two dates, in hours, based off the following information:

ExcelQuestion.png



I have seen this post http://www.excelforum.com/excel-form...-weekends.html

I have also tried this formula: "=NETWORKDAYS(A1,B1)-1-MOD(A1,1)+MOD(B1,1)"

This would work if I had the date like so:

ExcelQuestion2.png


But the way the information is collected is different being that the date and time are in different cells. Otherwise that would work for me. If there is not a viable option, we can always alter a few things in order to make it work, but it would be preferred to have the data captured the current way with no alterations.

Thank you all for your help!