0
How can you round total time to the nearest quarter hour using Excel?
Wiki User
∙ 14y ago
Try this, substitute B2 and A2 with the cells you are trying to round =(ROUND(B2*96, 0)/96)-(ROUND(A2*96, 0)/96)
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
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.
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 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.
Total number of formulas in Excel?
The amount of formulas that can be done in Excel is infinite.
Add and round the sum as indicated 3 254 7 241 and 6 754 round the sum to the nearest hundred?
My best guess is that you want the sum of 3,254 + 7,241 + 6,754, rounded to the nearest hundred. If that is the correct interpretation of the question, you should add the numbers first and then round the total; don't round the individual numbers before adding them. 3,254 + 7,241 + 6,754 = 17,249, which rounds to 17,200
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
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.
How can you Convert quarter hours to semester hour?
Divide the number of quarter hours by 1.5ex:qrt. hr sem hr.1 .672 1.343 24 2.67... ...10 6.6720 13.3430 2040 26.67To convert quarter hours into semester hours, add up ALL of the quarter hours and multiply the total by .67 (which is the same as multiplying by 2/3). You can round off the decimal.EXAMPLE: 40 quarter hours x .67 = 26.8 semester hours.To convert semester hours into quarter hours, you divide the total number of quarter hours by 1.5
What percentage of the matter in our solar system condensed to form the sun?
100%, if you round to the nearest percent... From Wikipedia: "... accounting for about 99.86% of the total mass of the Solar System".
How can you do the total of date in excel?
ask me plz...
