Writing time whitout using :

[sprenger]

I want to type a time as 0800, instead of 08:00, I have
userformatet the cells t:mm, how can I solve this, so I
don't have to use : ??

 

[Frank Kabel]

Hi
only with VBA (using an event procedure) have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm

 

[Harald Staff]

As you may know, 1 is 24 hours, 1 day, in Excel. So 8:00 is 1/3,
0.33333333.... You want to enter eight hundred and end up with 0.33333 .
Excel doesn't destroy entries like that so this requires a macro. See
http://www.cpearson.com/excel/DateTimeEntry.htm for one solution.

HTH. Best wishes Harald

 

[Dreamboat]

Chip Pearson is the best. Check out his Quick Entry for Date/Time
http://www.cpearson.com/excel/DateTimeEntry.ht

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Hope this helps
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.com

 

[James Silverton]

As you may know, 1 is 24 hours, 1 day, in Excel. So 8:00 is 1/3,
0.33333333.... You want to enter eight hundred and end up with 0.33333 .
Excel doesn't destroy entries like that so this requires a macro. See
http://www.cpearson.com/excel/DateTimeEntry.htm for one solution.

HTH. Best wishes Harald

It's an interesting problem and, while I am grateful for the VBA
solutions to a problem that I also have faced, I wonder that the Excel
programming people have never noticed that there is a world outside
Redmond where people do write the time as, eg. 2350? It does not seem
that it should be terribly difficult to include the non-colon format
as a time format choice. IMHO, there are very few practical uses for
Military or Universal time where precision beyond seconds is required.
For my own purposes, if I have the date in the first column and the
non-colon time in the next, the calculation is not impossible without
resorting to VBA.