Thread: Time Formular
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Time Formular

=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