Google Groups Home
Help | Sign in
microsoft.public.excel.misc
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Message from discussion Adding the semicolon automatically in date format
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Ragdyer  
View profile  
 More options Jun 23 2006, 3:06 pm
Newsgroups: microsoft.public.excel.misc
From: "Ragdyer" <RagD...@cutoutmsn.com>
Date: Fri, 23 Jun 2006 12:06:23 -0700
Local: Fri, Jun 23 2006 3:06 pm
Subject: Re: Adding the semicolon automatically in date format
Reply to author | Forward | Print | View thread | Show original | Report this message | Find messages by this author
If you prefer a *non-code* work-around, you could use "AutoCorrect".

<Tools> <AutoCorrect>
In the 'Replace' box, enter 2 periods ( .. ),
In the 'With' box, enter a colon ( : ),
Then <OK>

Now, when it's necessary to enter times, keep your fingers on the num keypad
and enter
9..
And you'll get 9:00 AM,

Enter
12..45
And you'll get 12:45 PM

Neat trick for folks who are adept in 10 key!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ThereJustNow" <ThereJustNow.29v53c_1151079605.9...@excelforum-nospam.com>
wrote in message
news:ThereJustNow.29v53c_1151079605.9519@excelforum-nospam.com...

> I use Excel to enter the start and end time of an employee and the 3rd
> cell calculates the number of hours worked. The formula works great,
> however it would be so much faster if I could avoid having to type the
> ":" each and every time.

> Is there a way to add the semicolon automatically, or alternately have
> the ability to type "1400" and have it see "14:00"?

> Thanks very much,

> James Norton

> --
> ThereJustNow
> ------------------------------------------------------------------------
> ThereJustNow's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=35720
> View this thread: http://www.excelforum.com/showthread.php?threadid=555035


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google