Re: Working with times in military/international format.

Tech-Archive recommends: Fix windows errors by optimizing your registry

You could convert the data with=--TEXT(A1,"00\:00")
--
David Biddulph

"MidWest Yankee" <MidWest Yankee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B07D1A39-F284-4E98-A585-E260C05CE77D@xxxxxxxxxxxxxxxx
I enter hundreds of start and stop times to determine room occupancy time.
I
would like to get away from inserting the colon in the time, which would
greatly enhance entries with the number key pad. How do I format a cell to
allow entry of a 4 digit time (e.g. 1955 or 2315) in
military/international
format? I need to subtract Start from Stop Time, but the answer can be in
hh:mm format.

Thank You in advance for any helpful suggestions.


.

Relevant Pages

  • Re: Output to txt:
    ... Then to follow, are all the entries ... : column entry. ... To get around this for now, I format the output as html ... Word stores a file with embedded code to display it as it is seen on screen ...
    (microsoft.public.scripting.vbscript)
  • Re: Need help with import *.ldf
    ... An import file will not use the same format as an exported file will. ... The only time you use the changetype of add is when you are ... changetype: modify ... removes all of your old entries. ...
    (microsoft.public.exchange.admin)
  • Re: QDE (Quick Date Entry)
    ... > ambiguous entries interpretted. ... I'm with you that an *individual* user has his format and sticks to it. ... > functionality just ain't that complicated. ... What one can argue about is if using ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need help with import *.ldf
    ... I think de format of the senderfilter.ldf file is correct. ... I also suspect you'd need to have all the old entries in there ... Read my blog! ... Refer to the following site for ldifde help. ...
    (microsoft.public.exchange.admin)
  • Re: QDE (Quick Date Entry)
    ... The user DOES NOT have to enter dates in yyyy-mm-dd format. ... alternative 2- or 3-digit short date entry treatment. ... QDE is the logical opposite of a one-size-fits-all approach. ... I'll admit my macro doesn't handle such entries ...
    (microsoft.public.excel.worksheet.functions)