0
When working in excel if I enter a time from 7am to 5pm how do I get the formula to calculate the hours?
Wiki User
∙ 14y ago
Enter the 7am as 7:00 and the 5pm as 17:00 and then subtract the 7:00 from the 17:00. If you put the 7:00 into cell B3 and the 17:00 in B4, then in another cell you could put the following formula:
=B4-B3
That will give you 10:00
If you then want to use the 10 in a calculation, say to work out pay based on the amount of hours worked, first you need to extract the 10 from the time. If the 10:00 was in cell B5 then your formula would be:
=HOUR(B5)
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you calculate the mean of data using Excel?
Pick a cell in which to enter your formula Type: =average( then highlight the cells you wish to average. Press enter.
What type of entry does Excel assume you are?
Excel assumes data is text initially, but can treat it differently depending on the way you enter it. That is why you enter an equals sign at the beginning of a formula to indicate to Excel that you are creating a formula.
What formula is used to calculate quantity?
You can calculate quantity in Excel with the SUM function.
A calculation used in excell?
Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.
Where does excel display the data as you enter it?
in the cell and in the formula bar
What is it called where excel displays data as you enter it?
formula bar
What is the area of the excel window in which you enter and edit data?
cell or formula bar!
How do you enter 0.2 x 0.8 in excel?
=.2*.8 Enter that exactly in the cell and press enter. It should calculate it for you.
How do you calculate fat in milk using Excel formula in Microsoft Excel spreadsheet?
You would first need to know how the fat in milk is calculated and have a formula for it. You would need to know what values are needed to do it. Then you would need to get the values you need and enter them into cells in the spreadsheet. Using these cell references to build your formula, you could do the calculation.
What is a budget related to Excel?
Businesses and individuals often require to calculate a budget. A spreadsheet, such as Excel, can be used to do these calculations. Excel is ideal for working with budgets, as it is specifically designed for working with numbers.
When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?
first
Mathematical equation assigned to a cell that Excel uses to calculate a result?
formula
