Re: [IRCA] 24 hour clock in Excel

["Mark McCarthy" <mark.mccarthy@xxxxxxxxxxx>]

Hi Bob,

Another way in old Excel 2002 ...

Select
  the column or whatever range you want to format
  format
  cells
  number
  custom
Replace what's in the first box below the word "Type:" with hh:mm
Select enter and you're done.

Excel remembers this custom format, but only for this workbook :(

You must use a colon when entering data, i.e. 5:40, not 540, but that's
easier for me to remember than typing an apostrophe and sometimes a leading
zero. If you don't want the colon to display, use hhmm instead of hh:mm
above, but you still must use the colon when entering the data.


Mark, KE7MSU



----- Original Message ----- 
From: "Bob Coomler" <w6rjc@xxxxxxxxx>
To: <irca@xxxxxxxxxxxxxxxx>
Sent: Sunday, September 14, 2008 3:14 PM
Subject: [IRCA] 24 hour clock in Excel


> This probably should be simple, but I'm lost.  I'm setting up Excel
spreadsheets for my primary logging program (not at all happy with the
pre-packaged ones).  How can I get it to show a leading zero when using the
24 hour clock: i.e. 0500?  No matter what I seem to do, it will show as 5:00
or 500.  There has gotta be a way!  Thanks for any suggestions.
>
> Bob Coomler
> Cloverdale, CA
> _______________________________________________
> IRCA mailing list
> IRCA@xxxxxxxxxxxxxxxx
> http://montreal.kotalampi.com/mailman/listinfo/irca
>
> Opinions expressed in messages on this mailing list are those of the
original contributors and do not necessarily reflect the opinion of the
IRCA, its editors, publishing staff, or officers
>
> For more information: http://www.ircaonline.org
>
> To Post a message: irca@xxxxxxxxxxxxxxxx
>
>


_______________________________________________
IRCA mailing list
IRCA@xxxxxxxxxxxxxxxx
http://montreal.kotalampi.com/mailman/listinfo/irca

Opinions expressed in messages on this mailing list are those of the original contributors and do not necessarily reflect the opinion of the IRCA, its editors, publishing staff, or officers

For more information: http://www.ircaonline.org

To Post a message: irca@xxxxxxxxxxxxxxxx