I can imagine a formula with 8 nested if's. Can't you? But wouldn't 7.5 minutes (that's 7 minutes and 30 seconds) make more sense?
Details depend in the programming language you're using, but you should be able to do it in any language you've mastered in a somewhat more than elementary level.
I need the formula to round up or down based on 7min and 50 secs.
So 8:07:50 rounds up to 8:15:00
and 8:07:49 rounds down to 8:00:00
Can you Help?