how do I get a current time using =TODAY() instead of 12:00 AM

[Keith]

In Excel, If I format a cell with date and time and enter =today( )
I get the correct current date and a time of 12:00 AM
Never the current time. How do I get the current time?
If I enter =NOW( ) I get the correct current time.
Thanks.
Keith

[Marcelo]

Hi Keith

use =Now() and format as mm/dd/aaaa hh:mm

HTH
Regards from Brazil
Marcelo

"Keith" escreveu:

> In Excel, If I format a cell with date and time and enter =today( )
> I get the correct current date and a time of 12:00 AM
> Never the current time. How do I get the current time?
> If I enter =NOW( ) I get the correct current time.
> Thanks.
> Keith

[Keith]

Sorry, I should have stated that I wish the time and date to remain static,
never changing.

"Marcelo" wrote:

> Hi Keith
>
> use =Now() and format as mm/dd/aaaa hh:mm
>
> HTH
> Regards from Brazil
> Marcelo
>
> "Keith" escreveu:
>
> > In Excel, If I format a cell with date and time and enter =today( )
> > I get the correct current date and a time of 12:00 AM
> > Never the current time. How do I get the current time?
> > If I enter =NOW( ) I get the correct current time.
> > Thanks.
> > Keith

[Toppers]

use =NOW()??!!!

"Keith" wrote:

> In Excel, If I format a cell with date and time and enter =today( )
> I get the correct current date and a time of 12:00 AM
> Never the current time. How do I get the current time?
> If I enter =NOW( ) I get the correct current time.
> Thanks.
> Keith

[Keith]

I want the date and time to be static. =NOW( ) changes everytime I open the
worksheet.

"Toppers" wrote:

> use =NOW()??!!!
>
> "Keith" wrote:
>
> > In Excel, If I format a cell with date and time and enter =today( )
> > I get the correct current date and a time of 12:00 AM
> > Never the current time. How do I get the current time?
> > If I enter =NOW( ) I get the correct current time.
> > Thanks.
> > Keith

[Toppers]

Keith,
If you want a static date/time you will need to use VBA to
assign NOW() to your required cell(s).

What event determines if/when the date/time changes (as opposed to everytime
the w/book is opened)?

"Keith" wrote:

> I want the date and time to be static. =NOW( ) changes everytime I open the
> worksheet.
>
> "Toppers" wrote:
>
> > use =NOW()??!!!
> >
> > "Keith" wrote:
> >
> > > In Excel, If I format a cell with date and time and enter =today( )
> > > I get the correct current date and a time of 12:00 AM
> > > Never the current time. How do I get the current time?
> > > If I enter =NOW( ) I get the correct current time.
> > > Thanks.
> > > Keith

[Gord Dibben]

Keith

To enter a static date use CTRL + ;(semi-colon)

To enter static Now time use CTRL + SHIFT + ;(semi-colon)

To get both in same cell with space between CTRL + ;

Let go of CTRL and hit <space> then CTRL + SHIFT + ;

Format to dd-mm-yyyy hh:mm


Gord Dibben MS Excel MVP

On Mon, 26 Jun 2006 10:30:03 -0700, Keith <Keith@discussions.microsoft.com>
wrote:

>I want the date and time to be static. =NOW( ) changes everytime I open the
>worksheet.
>
>"Toppers" wrote:
>
>> use =NOW()??!!!
>>
>> "Keith" wrote:
>>
>> > In Excel, If I format a cell with date and time and enter =today( )
>> > I get the correct current date and a time of 12:00 AM
>> > Never the current time. How do I get the current time?
>> > If I enter =NOW( ) I get the correct current time.
>> > Thanks.
>> > Keith

[Bearacade]

You can't.

Today returns the date, not the time.

[Keith]

OK. Thanks.

"Bearacade" wrote:

>
> You can't.
>
> Today returns the date, not the time.
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=555679
>
>

[Marcelo]

Hi Keith, what about to use =now() copy and past special values?

HTH
regards from Brazil
Marcelo

"Keith" escreveu:

> OK. Thanks.
>
> "Bearacade" wrote:
>
> >
> > You can't.
> >
> > Today returns the date, not the time.
> >
> >
> > --
> > Bearacade
> >
> >
> > ------------------------------------------------------------------------
> > Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> > View this thread: http://www.excelforum.com/showthread...hreadid=555679
> >
> >

[Keith]

Got it worked out using a user defined function in visual basic.

Thanks for the assistance.

Keith

"Keith" wrote:

> In Excel, If I format a cell with date and time and enter =today( )
> I get the correct current date and a time of 12:00 AM
> Never the current time. How do I get the current time?
> If I enter =NOW( ) I get the correct current time.
> Thanks.
> Keith