Prev: Affect a new connection to a pivot table
Next: SUMIF WITH OR
From: Rebecca on 17 Mar 2010 18:51
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
From: Dave Peterson on 17 Mar 2010 19:12
=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
From: Gord Dibben on 17 Mar 2010 19:15
=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 <jones(a)btinternet.com> 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?

From: L. Howard Kittle on 17 Mar 2010 19:13
Ctrl+Shift+: (colon) will give you current time. However, it is not
volitaile like =Today() is.

HTH
Regards,
Howard

"Rebecca" <jones(a)btinternet.com> wrote in message
news:9BCB0E4E-92D4-43FF-A774-FBF1D2B2DBE1(a)microsoft.com...
> 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


From: Rebecca on 17 Mar 2010 20:19
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
> .
>
 | 
Pages: 1
Prev: Affect a new connection to a pivot table
Next: SUMIF WITH OR