Hi Everyone,
Hopefully this is an easy question for someone. Just as there is the
formular to enter today's date ie: =today(). Is there a similer formular to
enter the present time?
--
Thanks Becky

=now()
will include both the time and date.

=mod(now(),1)
will be just the time
(give it a nice format to remove the date)

Rebecca wrote:

Hi Everyone,
Hopefully this is an easy question for someone. Just as there is the
formular to enter today's date ie: =today(). Is there a similer formular to
enter the present time?
--
Thanks Becky

--

Dave Peterson

Ctrl+Shift+: (colon) will give you current time. However, it is not
volitaile like =Today() is.

HTH
Regards,
Howard

"Rebecca" wrote in message
...
Hi Everyone,
Hopefully this is an easy question for someone. Just as there is the
formular to enter today's date ie: =today(). Is there a similer formular
to
enter the present time?
--
Thanks Becky

=NOW() which is volatile and will update whenever calculation takes place

Or just hit CTRL + SHIFT + ; to enter a static time.

To enter a static date hit CTRL + ;


Gord Dibben MS Excel MVP

On Wed, 17 Mar 2010 15:51:01 -0700, Rebecca wrote:

Hi Everyone,
Hopefully this is an easy question for someone. Just as there is the
formular to enter today's date ie: =today(). Is there a similer formular to
enter the present time?

Spot on Dave. Thanks
--
Thanks Becky


"Dave Peterson" wrote:

=now()
will include both the time and date.

=mod(now(),1)
will be just the time
(give it a nice format to remove the date)

Rebecca wrote:

Hi Everyone,
Hopefully this is an easy question for someone. Just as there is the
formular to enter today's date ie: =today(). Is there a similer formular to
enter the present time?
--
Thanks Becky

--

Dave Peterson
.