ExcelBanter - Time At Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time At Excel (https://www.excelbanter.com/excel-discussion-misc-queries/185701-time-excel.html)

Suleman[_2_]

Time At 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

Niek Otten

Time At Excel

=NOW()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Suleman" wrote in message ...
| 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

Gord Dibben

Time At Excel

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

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

Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 12:30:30 -0700, Suleman
wrote:

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

All times are GMT +1. The time now is 08:41 PM.