I'm trying to do the exact same thing and it isn't working... Help? The total time is = Prep Time + (End Time - Start Time)  I want to ROUNDUP the total time to the nearest quarter hour and was trying this formula to the nearest half hour and it does...