Hi all,

I'm new to the forums and new to excel functions and programming. I'm trying to create a custom ROUND function that will allow me to do the following:

I'm working on a spreadsheet for a university game room that tracks times and then applies a dollar amount based on time played.

For example:

If someone plays a game for an hour from 1:00 pm to 2:00 pm they will be charged 1 for that hour. (1 per/hour)

What I want to do is allow a grace period so that if someone played an extra fifteen minutes they would still only get charged the rate for one hour of play.

So, if someone played from 1:00 - 2:15 they would be charged 1 dollar but if they played from 1:00 -2:16 (or longer) they would be charged 2 dollars.

Is there a way to create a custom formula that could allow this?