Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |