Get instant live expert help on what is the nearest hundredth
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hello, I have times in cells and I need to do some disproportionate rounding. I need to round the minutes as follows:
12:51 to 13:05 rounds to nearest qtr interval of 13:00
13:06 to 13:20 rounds to nearest qtr interval of 13:15
12:21 to 13:35 rounds to nearest qtr interval of 13:30
12:36 to 13:50 rounds to nearest qtr interval of 13:45
13:51 to 14:05 rounds to nearest qtr interval of 14:00
And so on. I can't get my head around this at all!
Solved by Z. Q. in 30 mins
I need a formula to find the nearest time value cell
Solved by X. Q. in 16 mins
I'm having trouble with excel round up to nearest 5. I need to multiple a column then round to the nearest 5 whole dollar while staying in a single column so i need to take the product then round it to the nearest 5
Solved by B. B. in 28 mins
I need help with round in excel. I want to round up but my spreadsheet automatically round to the nearest number.
Solved by T. W. in 26 mins
I want to change my entire spread sheet to give values to the nearest £100
Solved by X. U. in 24 mins