In this example I try to make an exercise the combination of HOUR and MINUTE.
In this case I use HOUR to get hour from the Diff. column and MINUTE from Diff. Column.
In Hour to minute column, we multiply Hour to 60 (=E4*60).
The formula in Total in minute is =HOUR(D4)*60+MINUTE(D4)
The formula in Grand Total is =H4*$E$2
I use $ for cell E2 to make absolute value
The output result is:
In this example I try to make an exercise the combination of HOUR and MINUTE.
In this case I use HOUR to get hour from the Diff. column and MINUTE from Diff. Column.
In Hour to minute column, we multiply Hour to 60 (=E4*60).
The formula in Total in minute is =HOUR(D4)*60+MINUTE(D4)
The formula in Grand Total is =H4*$E$2
I use $ for cell E2 to make absolute value
The output result is:
Choose the cell you want.
Use the menu option Data | Validation.
Click Input Message tab, type title you want in the title box then type the message in the input message.
Result: when you select that cell, it will show the title and the input message.
Right click on the name sheet that will be changed.
Choose Rename.
Type the new sheet name and press enter.
On the Insert menu, click Worksheet.
One sheet will be added in sheet tabs.
Create a drop-down list in Microsoft Excel is easy.
Along with this, I give you an example.
First, type the names below in the A column from cell A1 to cell A5:
Ari
John
Klark
Michael
Patric
I assume that we will create a drop-down list in cell C1.
The step that you should do:
On the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.
Click the Source box and block cell A1 until A5 then clik Ok
See the result below:
To create an automatic data in Microsoft Excel is easy.
The advantage of using automatic data is we as a user, do not need type a routine words. For example, we have the list below:
Acapulco
Miami
Puerto Rico
San Francisco
San Juan
The step to create new list:
Click Tools
Click Options
Click Custom Lists tab
Click NEW LIST to create
The cursor will move to List Box Entries
Type the all cities name lists that we have
Don’t forget press ENTER after you type any city.
Click Add then click OK
To see the result, you just type Acapulco then move the mouse to the bottom on the right corner and it show plus sign.
After you click and drag you should see ..
So when we need those lists, we just type Acapulco then click & drag to show the rest of the words.
Exercise 1 (VLOOKUP)
Please type Table 2 in cell A8.
Type Number, City in cell A9, Age in cell B9 and Age in cell C9.
Fill in 1 to 4 under Number column.
Type Miami, Ketchikan, Seattle and Vancouver under City column.
Type 34, 61, 23 and 45 under Age column.
For Table 1
Please type Number, Name, City, Age start in cell A1,B1 and so forth.
Fill in 1 to 4 and name under Number and Name column.
Please use VLOOKUP function to fill City and Age column.
The output result is below:
So the formulas that we use:
=VLOOKUP(A3;$A$10:$C$13;2)
=VLOOKUP(A3;$A$10:$C$13;3)