I need to make a payroll notice for new staff/current staff (when they change hours) I want the form to calculate the hours for the inputted shift per day. (i.e. Monday-9am-5pm= 8hours) I figured out how to get this calculation but my problem is trying to input the shift when its an overnight shift. (i.e. Monday 11pm to 9am tuesday morning). Any ideas?

Well you need to convert your elapsed time into a number value in hours since you want to round to the quarter hour. This isn't the knowledge base article that I remembered when I first went to look. Other approaches might do more than "Round down" to a 15 minute interval.

But if you take your elapsed time calculation, divide the result by 3600 (the number of seconds in an hour) and specify a number result type, you get the number value that you'd need to use with this knowledge base article.

All in one calculation might look like this:

Let ( Interval = (original interval calc here ) / 3600 ;

Int ( interval ) + Choose (....

)