by Wyn Hopkins

The Challenge: Hours from Start and End

  • Assume Start Time and Stop Time are always whole hours
  • Solution must handle new rows of data being added to the source with new staff names
  • Remove any records marked as “exclude” in the Status column (handle upper case / lower case typos)

Our approach…

Your submissions…

Here are some of the submissions we received – August 2022 Power Query Challenge Submissions