Then press the Enter key to see the result. There are two additional methods for using the DURATION function in Excel. Method one is to click the fx button on the top left of the Excel worksheet.

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.