Sum and round time in the same cell

[jeananotgina]

Hi, I have a time sheet that has

• clock-in in cell B9
• time for lunch in cell c9
• clock out in cell d9
• formula for total time worked in cell e9  which is currently: =SUM(D9-B9)-C9/24

What I need is a formula to also have the results in E9 rounded to the nearest 15 minutes.  Any suggestions?  I know how to do it if I want the rounded results in another cell but I'd like it to be in the same cell (E9) instead.  Screenshot is attached

Thanks in advance.

[#2]

@jeananotgina 

You may wrap your formula like

=MROUND( SUM(...), "00:15")

and apply time format to the result.

[#3]

@Sergei Baklan Tell me how one acquires this knowledge!!!  Thank you so much, seriously, I had scoured the internet.  Much appreciated.

[#4]

@jeananotgina , you are welcome.

By the way, if google "excel round time" first will be returned is Excel formula: Round time to nearest 15 minutes | Exceljet