0100 (24 hour) time - Which format??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeR-Oz - 12 May 2008 02:45 GMT

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

Reply to this Message

Max - 12 May 2008 03:24 GMT

You need to custom format the col as: hh:mm
then enter the times with a colon, eg: 00:00

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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) .
[quoted text clipped - 3 lines]
> Cheers
> Mike

Reply to this Message

MikeR-Oz - 12 May 2008 04:18 GMT

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

> You need to custom format the col as: hh:mm
> then enter the times with a colon, eg: 00:00
[quoted text clipped - 5 lines]
> > Cheers
> > Mike

Reply to this Message

Max - 12 May 2008 06:52 GMT

> .. 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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> YOur a good lad Max, I appreciate the support.
>
[quoted text clipped - 3 lines]
> Cheers
> Mike

Reply to this Message

Rate this thread: