15-minute interval aggregation PHP $midpoint = floor(($minutes+7)/15)*15; JavaScript midpoint = Math.floor((minutes+7)/15)*15;