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" <[EMAIL PROTECTED]> To: <[email protected]> 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 > [email protected] > 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: [email protected] > > _______________________________________________ IRCA mailing list [email protected] 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: [email protected]
