How to manage hours and rounding in Excel [Solved/Closed]

Theresa - Jun 17, 2017 at 11:07 PM - Latest reply:  Theresa
- Jun 19, 2017 at 03:13 PM

I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E7-D7). The result is 9:46 for example. I need this number to also be rounded to the nearest 15 minutes in the SAME cell though. Is this even possible? Please help.

See more 

2 replies

TrowaD 2369 Posts Sunday September 12, 2010Registration dateModeratorStatus June 21, 2018 Last seen - Jun 19, 2017 at 11:22 AM
Thank you
Hi Theresa,

The numerical value of 15 minutes in Excel is 0.0104166666666667.

So we need to round your time closest to the multitude of that number:
=MROUND((C7-B7)+(E7-D7), 0.0104166666666667)

Best regards,
Thank you! All fixed.