Best Answer

Try this, substitute B2 and A2 with the cells you are trying to round =(ROUND(B2*96, 0)/96)-(ROUND(A2*96, 0)/96)

User Avatar

Wiki User

โˆ™ 2009-06-09 20:00:28
This answer is:
User Avatar
Study guides


20 cards

A polynomial of degree zero is a constant term

The grouping method of factoring can still be used when only some of the terms share a common factor A True B False

The sum or difference of p and q is the of the x-term in the trinomial

A number a power of a variable or a product of the two is a monomial while a polynomial is the of monomials

See all cards
1175 Reviews

Add your answer:

Earn +20 pts
Q: How can you round total time to the nearest quarter hour using Excel?
Write your answer...
Still have questions?
magnify glass
Related questions

What do you get when you round 4583304 to the nearest thousand?

You get a total of 458300.

What is the past tense form of round?

Round is a regular verb so past and past participle are rounded.He rounded the total to the nearest dollar.

Does 15 round up to a total of 10 or 15?

15 rounds to 15 if you are rounding to the nearest whole number. If you are rounding to the nearest five, then 15 still rounds to 15. If you are rounding to the nearest ten, then 15 would round up to 20.

Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.

What to do if the money total has a repeating decimal?

round off to nearest one hundredth; for example 1.444444.. = 1.44

Total number of formulas in Excel?

The amount of formulas that can be done in Excel is infinite.

When you round the atomic mass on the periodic table to the nearest whole number what does it represent?

Mass number (total number of protons and neutrons)

How much do you win from Wimbledon?

Losers of the first round - 10,250 Losers of the Second round- 17,000 Losers of the Third round - 28,125 Losers of the Fourth round- 50,000 Quarter-Finalists- 93,750 Semi-Finalists- 187,500 Runner-Up- 375,000 WINNER- 750,00 IN TOTAL - 3,925,000

How can you do the total of date in excel?

ask me plz...

A lab technician is mixing a solution and needs to convert 5 gallons to liters. Calculate the total liters. Round to the nearest hundredth.?

18.93 L

How to Calculate quarter over quarter revenue?

How to calcalate total revenue

What is 239.00 plus 8.25 tax?

$258.72 would be the total. You take the sale amount of $239.00 and multiply it by 1.0825 and it will give you the total of the sale and sales tax added and you have to round it to the nearest cent.

People also asked