I am trying to find a formula that works out the business hours between two dates in excel.
The business hours start at 09:00 and end at 17:00 and do not include weekends.
The spreadsheet is currently laid out in the following way;
A1: Start Time - B1: End Time - C1: Total Business hours A2: 2016-01-04 10:31:17 - B2: 2016-01-06 10:02:14
Is there a formula I can use that will calculate the difference in time (business hours) and display it in C2?