LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default default time to PM after 12:00 pm

Currently Excel defaults to AM when entering a time. Does anyone know if I
can make default to PM when entering a time I know should be after 12:00pm?
I can't figure out how I can let Excel know I mean 1:00 PM rather than 1:00
AM without typing in the PM.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time format shows default of 12:00 AM Helene Excel Worksheet Functions 6 February 7th 10 05:58 PM
Default date and time in the comment. Gary Excel Worksheet Functions 4 January 16th 07 11:17 PM
HOW DO YOU SET THE DEFAULT TIME FOR DATE IN EXCEL TO 8:00 AM? David Excel Discussion (Misc queries) 4 August 31st 06 02:52 AM
Problem with default date/Time mward04 Excel Worksheet Functions 3 March 13th 06 04:43 PM
Default Time GW Excel Discussion (Misc queries) 8 February 26th 06 06:54 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"