Home > Enterprise >  GOOGLE SHEETS - Arrayformula for duration between 2 datetime stamps ignoring weekends and our of hou
GOOGLE SHEETS - Arrayformula for duration between 2 datetime stamps ignoring weekends and our of hou

Time:10-25

I'm trying to work out the duration of 2 date/time stamps, ignoring out-of-hours and weekends. I have a formula that does individual durations (Column D) but when I try turning it into an array formula (Column E) it doesn't seem to work. I'm sure I have something slightly off and that is what is causing the issue.

I would greatly appreciate somebody taking a look at it.

Many thanks

enter image description here

  • Related