If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I change . to : when input in a time sheet by error
Have a time sheet, when entering time if I enter it as 09.30 how can I have
the system change this automatically to 09:30 when I enter it? |
#2
|
|||
|
|||
How do I change . to : when input in a time sheet by error
Just change the format from hh.mm to hh:mm
-- Gary's Student "geordie" wrote: Have a time sheet, when entering time if I enter it as 09.30 how can I have the system change this automatically to 09:30 when I enter it? |
#3
|
|||
|
|||
How do I change . to : when input in a time sheet by error
One trick is to use "Auto Correct".
For instance, if you're entering timecards on a Monday, with a large number of time entries, you can *temporarily* change the decimal (period) to the colon using Auto Correct. Tools Auto Correct Make sure "ReplaceTextAsYouType" is checked, And in the "Replace" box enter a period, and in the "With" box enter a colon, then OK. This will allow you to use the "10-key" num pad to enter all your times. When you're done, you can switch back to normal. If, on the other hand, you're looking for something to use throughout the entire work day, you might wish to make a *permanent* entry in Auto Correct, perhaps a *double* decimal (..) to denote a change to a colon. It's *almost* just as easy as the single decimal when using "10-key", but for *sure*, it's a heck of a lot easier then using the colon. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "geordie" wrote in message ... Have a time sheet, when entering time if I enter it as 09.30 how can I have the system change this automatically to 09:30 when I enter it? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fatal error during installation | Mitja | Setup, Installing & Configuration | 5 | December 13th, 2005 03:29 AM |
Input mask error message | hagen31 | General Discussion | 0 | September 27th, 2005 07:33 PM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |