fdg1966
asked on
calculate time difference without weekends and nights
I need to calculate the time difference (in hours and minutes) without weekends and nights between two date (with day and time format).
Wich access's expression i must use?
Wich access's expression i must use?
ok, what is your definition of a day as you have said not including nights
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It will, but you may have to adjust working hours start and end:
https://www.experts-exchange.com/questions/23604834/Difference-between-2-dates-in-Months-Days-Hours-Minutes.html?anchorAnswerId=22118601#a22118601
/gustav
https://www.experts-exchange.com/questions/23604834/Difference-between-2-dates-in-Months-Days-Hours-Minutes.html?anchorAnswerId=22118601#a22118601
/gustav
ASKER
Just a detail: how I can add my Holidays days in your code? In the holiday array?
Thanks
Thanks
https://www.experts-exchange.com/questions/23604834/Difference-between-2-dates-in-Months-Days-Hours-Minutes.html