How to Show Standard Time in NOW Function?

[bencar]

How do I use =NOW() to give me the current date (of course), but standard time, not military time. For ex, I want the time after the date to show as 4:00 not 1600.

 

[OGCV1]

Custom Format as dd/mm/yy hh:mm AM/PM

 

[bencar]

Custom Format as dd/mm/yy hh:mm AM/PM

I'm confused. How would I enter this into =NOW()?

 

[Peter_SSs]

I'm confused. How would I enter this into =NOW()?

You can use ..

=TEXT(NOW(),"dd/mm/yyyy hh:mm") (and you might want to swap the dd/mm part depending on your location & standard date format)

.. but then your cell will contain text, not a date/time. That means you wouldn't be able to, for example, subtract two such values to determine the difference between them.

If you want the cell to actually contain a date/time then you would leave =NOW() in the cell and custom format that cell (or column etc) as OGCV1 described, or perhaps as just dd/mm/yy hh:mm (again, you might want to swap the dd/mm part depending on your location & standard date format)

 

[bencar]

You can use ..

=TEXT(NOW(),"dd/mm/yyyy hh:mm") (and you might want to swap the dd/mm part depending on your location & standard date format)

.. but then your cell will contain text, not a date/time. That means you wouldn't be able to, for example, subtract two such values to determine the difference between them.

If you want the cell to actually contain a date/time then you would leave =NOW() in the cell and custom format that cell (or column etc) as OGCV1 described, or perhaps as just dd/mm/yy hh:mm (again, you might want to swap the dd/mm part depending on your location & standard date format)

Ahhh.. thank you so much.. its the answer I was looking for especially the part about custom formatting.. thank u again!

 

[Peter_SSs]

.. especially the part about custom formatting..

That was suggested to you first up.

Custom Format as dd/mm/yy hh:mm AM/PM

 

[bencar]

That was suggested to you first up.

It was never explained relating to NOW.

 

[Peter_SSs]

It was never explained relating to NOW.

Fair enough, but that is not what is usually referred to by the term "Custom Formatting".
Anyway, so long as you have what you want, all is well.

 

[OGCV1]

Fair enough, but that is not what is usually referred to by the term "Custom Formatting".
Anyway, so long as you have what you want, all is well.

Sorry didn't really elaborate on my answer, thanks Peter for making it clearer.