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?
Appreciate your help!
message edited by Brown94