How to manage hours and rounding in Excel
Solved/Closed
Related:
- How to manage hours and rounding in Excel
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- How to change author in excel - Guide
- How to open excel in notepad - Guide
- How to change date format in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 19, 2017 at 11:22 AM
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
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
Jun 19, 2017 at 03:13 PM