Question: how to calculate time in excel excluding weekends?
Answer: Open a new Microsoft Excel 2010 spreadsheet. ... 
Repeat this process with the ending date and time in cell B1.
Click on the cell where you want your result to appear, then enter "=NETWORKDAYS(A1,B1)-1-MOD(A1,1)+MOD(B1,1)", without the quotes.