ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Keyboard shortcut for current date and time (https://www.excelbanter.com/excel-worksheet-functions/265034-keyboard-shortcut-current-date-time.html)

Raj[_2_]

Keyboard shortcut for current date and time
 
Hi,

Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me

Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.

Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?

Thanks in advance.

Regards,
Raj

Jim Cone[_2_]

Keyboard shortcut for current date and time
 
CTRL+; then SPACE then CTRL+SHIFT+;
-or-
=Now()
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware



"Raj"
wrote in message
Hi,
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current time.
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.

Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?

Thanks in advance.
Regards,
Raj


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com