Shortcut for Time Now function

N

Nathan

Hi,

I'm tracking wait time data and have to continuously type in the time a
person begins a wait and the time they end the wait. I would like to have a
shortcut for the time now function [=NOW()], which I could use for each
entry. Is there a shortcut?

Thanks,
Nathan
 
R

Rick Rothstein \(MVP - VB\)

You can press Ctrl+; (that is the Control Key in combination with the
Semi-Colon Key) to get the current date and Ctrl+Shift+; to get the current
time. These are fixed text values and will not update like the value for the
NOW() and TODAY() functions to. To get the same output in a cell as the
NOW() function would produce, just execute the above keystroke combinations
with a space separating them. That is, key in this...

<Ctrl+;><Space><Ctrl+Shift+;>

where each separate keystroke combination is shown between angle brackets.

Rick
 
N

Nathan

Thanks Rick. This is perfect.

Rick Rothstein (MVP - VB) said:
You can press Ctrl+; (that is the Control Key in combination with the
Semi-Colon Key) to get the current date and Ctrl+Shift+; to get the current
time. These are fixed text values and will not update like the value for the
NOW() and TODAY() functions to. To get the same output in a cell as the
NOW() function would produce, just execute the above keystroke combinations
with a space separating them. That is, key in this...

<Ctrl+;><Space><Ctrl+Shift+;>

where each separate keystroke combination is shown between angle brackets.

Rick


Nathan said:
Hi,

I'm tracking wait time data and have to continuously type in the time a
person begins a wait and the time they end the wait. I would like to have
a
shortcut for the time now function [=NOW()], which I could use for each
entry. Is there a shortcut?

Thanks,
Nathan
Click to expand...
Click to expand...
 
Top