Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Entering Time

Newbie question - how do I enter Time, once I have cell formatted.

Let's say the time I want to enter, and the format I want, is 1:55 PM

So far, the only way I can get my input to format itself is by enter: 1:55
up

Might as well type the whole thing as text.

Am I missing a shortcut or two here ?
Thx

Dave


 
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
Entering Time & Then Adding It Jason Excel Discussion (Misc queries) 7 December 18th 07 05:39 PM
In Excel: Time Entering Reno747 Excel Worksheet Functions 2 November 30th 07 09:29 PM
Entering time Chris Excel Discussion (Misc queries) 4 June 27th 07 04:50 AM
entering time data nick carriero Excel Discussion (Misc queries) 1 January 27th 06 08:46 AM
Entering Time Macro [email protected] Excel Worksheet Functions 2 September 10th 05 09:09 AM


All times are GMT +1. The time now is 05:19 PM.

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

About Us

"It's about Microsoft Excel"