View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default how do I get a current time using =TODAY() instead of 12:00 AM

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