If logic error in excel data model

Hi  I am trying to create a measure to get results by time units every 15 minutes gap.  already tried these different measures but have not gotten the expected results. Please guide what mistake I ...