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
Hello there,
I need help. I need to put together a spreadsheet that will calculate the time between a start and end time. It also needs to round to the nearest quarter hour when it exceeds a point of
8. For example, if its between 12:00 and 12:08, then it rounds down to the nearest hour. If its between 12:09 to 12:15, then it rounds to the quarter hour. Like if my start time was 12:09 and my end time was 4:08 then it would calculate 3 Hours, 45 Minutes. Anyone out there know the formula for that? Please help...

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic