Time Formular

[Rebecca]

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?

 

[Dave Peterson]

=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)

 

[L. Howard Kittle]

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

HTH
Regards,
Howard

 

[Gord Dibben]

=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

 

[Rebecca]

Spot on Dave. Thanks
--
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)