If you need to display the current date and time in Excel or Google Sheets spreadsheet, you can do it quickly. There is more than one method to show the current date and time in a spreadsheet.

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 ...