Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Scott,
You can just combine the two with a space so Ctrl + ; space Ctrl + Shift + : It's a single handed operation if you use the right side of the keyboard. HTH Martin "Scotta0471" wrote in message ... I know that CTRL + ; gives the current date, and I know that CTRL + SHIFT + : gives the current time. Is there a keystroke that gives the current date AND time? I'd like to enter a start time quickly in one column and then a closing time in another and have it calculated in a third. The individuals who will be filling out this spreadsheet need a very quick and dirty way to do it. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Current date and time for different log entries | Excel Discussion (Misc queries) | |||
Current date and time when different cell = X | Excel Worksheet Functions | |||
How to show current date and time | New Users to Excel | |||
How do I sum within a set time frame from the current date? | Excel Worksheet Functions | |||
Can I automatically enter the current date or current time into a | New Users to Excel |