Using the NOW function
 

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?

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

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


--
Regards,
Dave


"Bill R" wrote:

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?

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


"Bill R" wrote in message
...
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?

Thank you! Works Great!

"David Billigmeier" wrote:

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

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


--
Regards,
Dave


"Bill R" wrote:

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?

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?

On Wed, 5 Oct 2005 10:11:03 -0700, "David Billigmeier"
wrote:

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

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