[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [IRCA] 24 hour clock in Excel
You need a custom format. Type "hh:mm" in the text window after you've
clicked on "custom" to create a new format that forces 2 hours digits and 2
minutes digits.
Chuck
-----Original Message-----
From: irca-bounces@xxxxxxxxxxxxxxxx [mailto:irca-bounces@xxxxxxxxxxxxxxxx]
On Behalf Of Russ Edmunds
Sent: Sunday, September 14, 2008 3:40 PM
To: IRCA List
Subject: Re: [IRCA] 24 hour clock in Excel
Format / Cells / Number / Custom will get you 00500...( so will the same
sequence but ending using "Zip Code" ) But so far I haven't figured that out
either, and I use Excel daily.
Russ Edmunds
Blue Bell, PA ( 360' ASL )
[15 mi NNW of Philadelphia]
40:08:45N; 75:16:04W, Grid FN20id
<wb2bjh@xxxxxxxxx>
FM: Yamaha T-80 & Onkyo T-450RDS w/ APS9B @15'
AM: Modified Sony ICF 2010 barefoot
--- On Sun, 9/14/08, Bob Coomler <w6rjc@xxxxxxxxx> wrote:
> From: Bob Coomler <w6rjc@xxxxxxxxx>
> Subject: [IRCA] 24 hour clock in Excel
> To: irca@xxxxxxxxxxxxxxxx
> Date: Sunday, September 14, 2008, 6:14 PM
> 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
_______________________________________________
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