New Contributor

# Sum and round time in the same cell

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

3 Replies

# Re: Sum and round time in the same cell

You may wrap your formula like

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

and apply time format to the result.

# Re: Sum and round time in the same cell

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

# Re: Sum and round time in the same cell

@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