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 ...
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