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!

Hi,
Welcome to the forum!!

Try this-

=(NETWORKDAYS(A1,C1)*24)-IF(NETWORKDAYS(C1,C1)=1,24-HOUR(D1),24)-IF(NETWORKDAYS(A1,A1)=1,HOUR(B1),0)

Check attached.

okay, I will correct myself.
Just did a small error
Change to the formula to this-

=(NETWORKDAYS(A1,C1)*24)-IF(NETWORKDAYS(C1,C1)=1,24-HOUR(D1),0)-IF(NETWORKDAYS(A1,A1)=1,HOUR(B1),0)

You are most welcome friend!!

Thank you for your feedback and reputation!!

Have a Great Day!