calc. time between 2 dates INCLUDING weekends!

[hina04]

Hi!

I need to calculate the time [h]:mm:ss between 2 different dates. working hours are monday-sunday & times are 05:00:00 - 18:00:00

Public Holidays should be excluded!

Example:

A complaint was lodged on 26/09/2017 09:00:00
Solved 29/09/2017 15:00:00

28/09/2017 is a PUBLIC HOLIDAY

I can do this calculation using networkdays to exclude weekends, but not sure how to include a 7 day week + public holidays.

Please help!

 

[pgc01]

Hi
Welcome to the board

You did not post which version of excel you have.

For excel 2010+ you can use instead the NETWORKDAYS.INTL() function that lets you define your weekend days (in this case none).