To apply the custom time format click Ctrl 1 to open the Format Cells dialog select Custom from the Category list and type the time codes in the Type box. A custom function must start with a Function statement and end with an End Function statement. Excel includes several built-in functionsRAND and NOW for examplethat dont use arguments.
Multiplication Formula Place the cursor in cell B6 and then type the equals sign Type B1 Type an asterisk for multiplication operations Type B2 Press the ENTER key.
Step 1 Open Microsoft Excel. In addition to the function name the Function statement usually specifies one or more arguments. Please see Creating a custom time format in Excel for the detailed steps. Create a simple formula in Excel On the worksheet click the cell in which you want to enter the formula.