Dec 29 2020 12:28 PM
Hi, I have a time sheet that has
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.
Dec 29 2020 01:13 PM
You may wrap your formula like
=MROUND( SUM(...), "00:15")
and apply time format to the result.
Dec 29 2020 01:25 PM
@Sergei Baklan Tell me how one acquires this knowledge!!! Thank you so much, seriously, I had scoured the internet. Much appreciated.
Dec 30 2020 09:24 AM
@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