>
0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224
Home / Blog /

Tips and Tricks 5: Excel Shortcuts – Entering the current date and time

Tips and Tricks 5: Excel Shortcuts – Entering the current date and time

by Brilliance Computer Training Academy & Services

 

You might want to insert the current date or time in Excel. Two easy shortcuts for this is: 

Ctrl + ; is a shortcut key  to enter the current date in a cell.

Ctrl + :  or  Ctrl + Shift + ; are shortcut keys to enter the current time in a cell.

Excel_insert_date_and_time

It should be noted though that once you have entered a date or time, these values are fixed.

Should you wish to enter a date or time that will constantly update each time that the Excel file opens or when Excel refreshes calculations, you will then rather want to use the following two functions.  

=TODAY() is used to insert the current date

=NOW() is used to insert the current date and time. However, how it is displayed in Excel all depends on how the number formatting is displayed. Below you will see a default display of the date and time. Then again, this is as is defined on your compter's regional settings, or in Excel's options.

Excel_insert_date_and_time_daily

But suppose I want to display the time only and for the date, I would like to display the day as you see blow. 

Excel_new_time_and_date_formatting

What is needed to change it as the format above, is to select the number formatting options on the Home Tab, select the Custom formatting options, and change the formatting accordingly as is displayed below.

For the date, in the Type dialogue box, I will enter "dd mmm yyyy". Note that the Sample box will display the expected result, in this case, 05 Aug 2016.

Excel_set_date_formatting

To see only the time instead of both the date and time, select the Custom formatting options again, and in the Type dialogue box, change the formatting to h:mm. Of course, you can set the time format according to your own preference.

date_and_time_number_format_2

Share this article

Leave a comment

Your email address will not be published. Required fields are marked *