Forum Discussion
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
Thanks in advance.
3 Replies
You may wrap your formula like
=MROUND( SUM(...), "00:15")and apply time format to the result.
SergeiBaklan Tell me how one acquires this knowledge!!! Thank you so much, seriously, I had scoured the internet. Much appreciated.
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
