Re: Entering time.

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/26/04 

Date: Wed, 26 May 2004 18:28:11 +0200

Hi
see:
ttp://cpearson.com/excel/DateTimeEntry.htm 

-- 
Regards
Frank Kabel
Frankfurt, Germany
J. Madden wrote:
> Is there a way I can enter time using a decimal instead of the colon
> and have it still figure using the 60 minute hour?
> 
> For example for 9:45 I want to enter it as 9.45 but have it treated
> as 9:45. This is only for speed in data entry.  I can use a ten key
> quicker then I can hit the colon.  I use military time if it helps.
> 
> Thanks,
> Joe

Relevant Pages

  • Re: Need to substitute text for faster data entry
    ... for an event procedure which will allow you this 'fast-entry' ... Frank Kabel ... Marcia wrote: ... > instead of the colon to enter the data. ...
    (microsoft.public.excel.misc)
  • Re: Enter Time
    ... Frank Kabel ... bd4 wrote: ... > Can I format cells and enter time without having to enter the colon? ...
    (microsoft.public.excel.misc)
  • Re: Performing calculation in active cell based on user input
    ... the payroll clerks get confused on military time conversions. ... the code a prompt to the user with a radio button for am or pm. ... The calculations would then proceed based on the selection. ... they have to enter a colon, that requires two entries, the shift and then the ...
    (microsoft.public.excel.programming)
  • Re: change regular 24 hour format to military time in excel
    ... Excel can easily handle military time without any adjustments. ... does need to be entered with a colon, ... more complex formulas to be able to add up the time for a time sheet. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Entering time.
    ... Madden" schrieb im Newsbeitrag ... > Yeah I have seen that, but I don't have a clue how to implement it. ... >>> can hit the colon. ... I use military time if it helps. ...
    (microsoft.public.excel)