Need FORMULA for Date subtract Date equal bussiness hour (don't count weekend)

Originally Posted by FDibbins

What did it do, what did you get? Did you custom format the cell as I suggested?

	A	B	C
1	5/21/2015 15:33:00	5/25/2015 16:53:40	73:20:40

C1=(NETWORKDAYS(A1,B1))+MOD(B1-A1,1)
custom formatted [h]:mm:ss;@

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Still confuse why you count 73:20:40 hours while Saturday and Sunday are weekends then result should be 49:20:40 hours? Please explain

Regards,
tt3