Excel Tips 28 - Display The Current Time in Excel Down to the Second

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!

Видео Excel Tips 28 - Display The Current Time in Excel Down to the Second канала TeachExcel