I have two dates in 2 cells. These dates include times,ie. dd/mm/yyyy hh:mm
1) I need to calculate the difference between the dates in hours.
2) This formula needs to exclude non-business hours (business hours = 9am until 5pm). So the difference between Day 1 - 17:00 until Day 2 - 10:00 would be 1 hour.
3) This formula also needs to exclude public holidays and weekends. So the difference between Friday - 17:00 until Monday 10:00 would be 1 hour.
Bookmarks