Previous Topic Next Topic

How to manage hours and rounding in Excel

Solved/Closed
Theresa - Updated on Jun 18, 2017 at 07:14 PM
 Theresa - Jun 19, 2017 at 03:13 PM
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.

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 19, 2017 at 11:22 AM
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
0
Theresa
Jun 19, 2017 at 03:13 PM
Thank you! All fixed.
0

Similar discussions

Uh-oh... You have reached your SMS limit for 24 hours.
anthonyjackson -
HelpiOS -

1 response
you have requested too many SMS codes. you must wait 24 hours to receive another
Meyusake -
HelpiOS -

3 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses