you can use “MROUND” command to round your digits to specific numbers and also round the time to specific time.
Here we are going to explain them with some example;
How to Round to Specific Digit in Excel;
How to round number to first digit.
If you have decimal digit and you want to round them to the digit without any decimals you can use this formula.
In this formula
“C5” is the cell name which we want to round their number.
“1” means that you want to round your number to the nearest number to the first digit.
How to round number to 0.5:
If you want you can round decimal to “0.5”
For that you can follow these steps;
How to round number to 10:
You can also round number to ten, for that you can follow this formula;
How to round number to 20:
you can also round number to other digits like “20” for that, for exapmle you can use
For number “20”.
How to round number to 100:
For rounding number to one hundred you can use this formula;
How to Round Time in Excel;
we can round time in excel cells to here we will explain it by two example.
In the column “C”, we have different times and in column “D” we want to round them to 15 and 30 minitue.
- For rounding time to 15 minitue write this formula.
In this formula “C5” is the address of the cell which you want to round the time on it.
Specify this formula to other cells.
Select the cells in the coulmn “D”.
Click on the “Home” tab.
In the Number part click on the arrow sign on the right bottom corner side or click on the drop down list.
Click on the “Number” tab and choose “Time”.
Choose your desired type for showing time.
Click on the “OK”.
You can see time on your cells were rounded to “0:15”.
- If you want to round time to 30 minitue you can use this formula.