Date and time in cell
 

Hi there,

I need a way of getting the latest date and time in a cell without having to
manually update it every minute!

I can't see to figure out how to do this. I need something like currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne

Date and time in cell
 

=NOW()


--


Regards,


Peo Sjoblom



"Grd" wrote in message
...
Hi there,

I need a way of getting the latest date and time in a cell without having
to
manually update it every minute!

I can't see to figure out how to do this. I need something like
currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne

Date and time in cell
 

Does =Now() do what you want?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Grd" wrote:

Hi there,

I need a way of getting the latest date and time in a cell without having to
manually update it every minute!

I can't see to figure out how to do this. I need something like currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne

Date and time in cell
 

=NOW()



"Grd" wrote:

Hi there,

I need a way of getting the latest date and time in a cell without having to
manually update it every minute!

I can't see to figure out how to do this. I need something like currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne

Date and time in cell
 

you need something like clocks on the internet? real time clock?! If so,
you'll need some VBA, if not =now() should do the job (as already
mentioned).

"Grd" wrote in message
...
Hi there,

I need a way of getting the latest date and time in a cell without having
to
manually update it every minute!

I can't see to figure out how to do this. I need something like
currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne

Date and time in cell
 

Perfect

Thanks

"Peo Sjoblom" wrote:

=NOW()


--


Regards,


Peo Sjoblom



"Grd" wrote in message
...
Hi there,

I need a way of getting the latest date and time in a cell without having
to
manually update it every minute!

I can't see to figure out how to do this. I need something like
currenttime.

Can anyone guide me.

Any help greatly appreciated.

Suzanne