Shortcut for Time Now function

[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

 

[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

 

[Nathan]

Thanks Rick. This is perfect.

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

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