Using the NOW function

[Guest]

The current date and time pulls but it does not specify am or pm. How can I
write a formula that will show the current time as am or pm?

 

[Guest]

Format->Cells->'Number' Tab->Custom and enter this formula:

[$-409]mmmm d, yyyy h:mm AM/PM;@

 

[Arvi Laanemets]

Hi

It's matter of format, you apply to cell with formula. Both date and time in
Excel are really numbers. P.e. inter into some cell the number 38630.75 -
when you format the cell with this number as "dddd", you get 'Wednesday'
displayed, when you format the cell as "yyyy/mm/d", then you get '2005/10/5'
displayed, when you format same cell as "h:mm:ss", then you get '18:00'
displayed, etc. You simply have to find the right format - probably some
ordinary time format will do (I myself use always 24-hour time).


Arvi Laanemets

 

[Guest]

Thank you! Works Great!

Format->Cells->'Number' Tab->Custom and enter this formula:

[$-409]mmmm d, yyyy h:mm AM/PM;@


--
Regards,
Dave

The current date and time pulls but it does not specify am or pm. How can I
write a formula that will show the current time as am or pm?

 

[Myrna Larson]

What is the purpose of the [$-409] at the beginning? I don't find anything
about this in Help. I assume it's a locale specification?