since Excel handles time as a fraction of a day, this formula will determine the total number of days using the NETWORKDAYS function then calculate the hour difference using the two MOD functions.

How to Calculate Hours in Excel Excluding Weekends ... Click the pop-out button next to the word "Number" to open the formatting options. Under "Category," select "Time." Then, select an option ...

To calculate hours worked, enter valid time values into B2 and C2. For example, enter 11:00 PM as the Time In and 7:00 AM as the Time Out, and Excel will display 8, the correct number of hours ...