Forum Discussion

Copper Contributor

Dec 29, 2020

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

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Dec 29, 2020

jeananotgina

You may wrap your formula like

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

and apply time format to the result.

jeananotgina
Copper Contributor
Dec 29, 2020
SergeiBaklan Tell me how one acquires this knowledge!!! Thank you so much, seriously, I had scoured the internet. Much appreciated.
- SergeiBaklan
  Diamond Contributor
  Dec 30, 2020
  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