Forum Discussion

NeilKloster's avatar
NeilKloster
Brass Contributor
Nov 15, 2022
Solved

calculate business hours in excel

Hello,    I am trying to figure out a way to write a variation of Excel's 'NETWORKDAYS' formula where it will calculate number of business days between a start date/time and an end date/time - and ...
  • HansVogelaar's avatar
    HansVogelaar
    Nov 15, 2022

    NeilKloster Perhaps, with the start date and time in A2 and the end date and time in B2:

     

    =NETWORKDAYS(A2,B2)-(HOUR(A2)>=23)-(HOUR(B2)<7)

     

    Format the cell with the formula as General.

Resources