google sheets – Cannot get Query to display time

I need help getting to show the result of a dropdown. If you look at C22, there’s a dropdown for a specific date. I’m currently working on row 24 and have applied the formulas I think should work. I got it to show the coins from May 25, but cannot get the Duration, Days, MTD Coins and MTD Hours for May 25 to show.

https://docs.google.com/spreadsheets/d/1XJyPEqNMxi2EhzSiUYpYOBMv5m59HD2dLx_Y7rFtGMs/edit?resourcekey#gid=958394600

Here’s what should happen. Selecting the date in C22 should display “Laugene’s” coins, Duration, Days, MTD Coins and MTD Hours.

Issues encountered (Row 24):

  1. Duration, Days, MTD Coins and MTD Hours are not showing.
  2. Total Duration and Days are not summing up on Col BN and BM

Any thoughts or suggestions?