Premium Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

How to display the current time in Excel using a function. Use the NOW() function in Excel to display the current date and time. You will also learn how to change the format of the cells so that you only view the current time, time with AM/PM, as well as the seconds (hh:mmmm:ss). You will also learn how to further change the formatting to get what you need from this function.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!