Time At Excel

S

Suleman

As If We Need a Date at Excel We Use =Today()
What About We Put The Formula If We Want DAte And Time Together in A cell?

Thanks In Advance
 
N

Niek Otten

=NOW()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| As If We Need a Date at Excel We Use =Today()
| What About We Put The Formula If We Want DAte And Time Together in A cell?
|
| Thanks In Advance
 
G

Gord Dibben

=NOW() formatted to mm/dd/yyyy hh:mm:ss

For static date/time use CTRL + ; <spacebar> CTRL + SHIFT + ; <Enter>


Gord Dibben MS Excel MVP
 
Top