Report

How to manage hours and rounding in Excel [Solved]

Ask a question Theresa - Last answered on Jun 19, 2017 at 03:13 PM by Theresa
Hello,

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.

Helpful
+0
plus moins
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,
Trowa
Theresa- Jun 19, 2017 at 03:13 PM
Thank you! All fixed.
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!