I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E7-D7). The result is 9:46 for example. I need this number to also be rounded to the nearest 15 minutes in the SAME cell though. Is this even possible? Please help.