Loading...

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

29,593 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Nov 9, 2009

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!

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...