Type the function =DURATION(B1,B2,B3,B4,B5,B6) into the cell you want to place the result. Then press the enter key to see the result. There are two other methods to use the DURATION function in ...

The space before "am" or "pm" tells Excel to format the data as time rather than plain text. Type the formula to display the hours worked in cell B4 and press "Enter." For example, type the ...

In Excel, the formula used to calculate a bond's modified duration is built into the MDURATION function. This function returns the modified Macaulay duration for a security, assuming the par value ...

Calculating the Macauley Duration in Excel . Assume you hold a two-year zero-coupon bond with a par value of $10,000, a yield of 5%, and you want to calculate the duration in Excel.