I don't supply exact formulae, but it would be very close to this...

(ROUND(MINUTES(A1) / 15)) * 15

It will not meet the exact 8 minute rule, but the effect is most likely what was wanted. The result is that the minutes in some cell A1 will ROUND to full 15 minute values. I leave you to ponder this.

Bob