Count business hours in a Spreadsheet

Reading Time: < 1 minutes

Convert date:

=DATE(2021,9,1)

Count business days:

=NETWORKDAYS(DATE(2021,9,1), DATE(2021,9,30))

Count business hours:

=MULTIPLY(NETWORKDAYS(DATE(2021,9,1), DATE(2021,9,30)),8)

Photo by Annie Spratt on Unsplash


About the author

Andrés Canavesi
Andrés Canavesi

Software Engineer with 15+ experience in software development, specialized in Salesforce, Java and Node.js.


Related posts


Leave a Reply

%d bloggers like this: