B
Bill R
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?
write a formula that will show the current time as am or pm?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Billigmeier
Format->Cells->'Number' Tab->Custom and enter this formula:
[$-409]mmmm d, yyyy h:mm AM/PM;@
[$-409]mmmm d, yyyy h:mm AM/PM;@
A
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
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
B
Bill R
Thank you! Works Great!
David Billigmeier said:Format->Cells->'Number' Tab->Custom and enter this formula:
[$-409]mmmm d, yyyy h:mm AM/PM;@
--
Regards,
Dave
Bill R said: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?