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

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" wrote in message
...
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

Thanks Rick. This is perfect.

"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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