Thread: Time Formular
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rebecca[_4_] Rebecca[_4_] is offline
external usenet poster
 
Posts: 8
Default Time Formular

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
.