|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2008, 02:45 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
0100 (24 hour) time - Which format??
Hi,
I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format type that retains these numbers as four digits (allows me to go to 2400) . Which format is it - I have tried several and it drops the first zero(0) off. Cheers Mike 
|
|
#2
May 12th, 2008, 03:24 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
0100 (24 hour) time - Which format??
You need to custom format the col as: hh:mm
then enter the times with a colon, eg: 00:00 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "MikeR-Oz" wrote: I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format type that retains these numbers as four digits (allows me to go to 2400) . Which format is it - I have tried several and it drops the first zero(0) off. Cheers Mike
|
|
#3
May 12th, 2008, 04:18 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
0100 (24 hour) time - Which format??
YOur a good lad Max, I appreciate the support.
I did try that format but wanted to be lazy and had hoped I would not have to add in the colon(  .Cheers Mike "Max" wrote: You need to custom format the col as: hh:mm then enter the times with a colon, eg: 00:00 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "MikeR-Oz" wrote: I wish to type in the cells 0100, 0200, 0300 etc but cannot see the format type that retains these numbers as four digits (allows me to go to 2400) . Which format is it - I have tried several and it drops the first zero(0) off. Cheers Mike
|
|
#4
May 12th, 2008, 06:52 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
0100 (24 hour) time - Which format??
.. wanted to be lazy .. would not have to add in the colon(
well, laziness has its price .. Go to Chip's page at: http://www.cpearson.com/excel/DateTimeEntry.htm 1. Install Chip's 2nd sub on the page 2. Custom format the input range (A1:A10) as: hh:mm and you' ready to roll .. ... and if you feel like it, press the "Yes" button below -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "MikeR-Oz" wrote: YOur a good lad Max, I appreciate the support. I did try that format but wanted to be lazy and had hoped I would not have to add in the colon( .Cheers Mike
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
