Count business hours in a Spreadsheet


Sep 06, 2021
featured image

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


spreadsheet