Current Time formula

[BenNV]

I'm using =Now() to find the current date and time. But I only require the current time. Can we use a formula or VBA to do this? I want the time to be unchangeable everytime the workbook calculates.

 

[Mark W.]

If you're only concerned about the display of a time value just apply a Time format to the cell containing NOW().

If you want to use just the time component of NOW() in a calculation use =MOD(NOW(),1) and apply a Time format.
This message was edited by Mark W. on 2002-05-09 08:08

 

[BenNV]

Thanks Mark. I still don't quite follow how to get rid of the date. Using the formula u gave I still get the date.

 

[Mark W.]

On 2002-05-09 08:09, BenNV wrote:
Thanks Mark. I still don't quite follow how to get rid of the date. Using the formula u gave I still get the date.

"If you want to use just the time component of NOW() in a calculation use =MOD(NOW(),1) and apply a Time format."

 

[merlin777]

i realise this thread is old but...

I use =NOW()-TODAY() and format as time.