Date formats English/US

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Glebe - 22 May 2008 14:45 GMT

I have some experience of using Excel (2003), but cannot do anything other
than very simple VBA. I have a piece of equipment (a blood glucose monitor),
which, being of US origin, displays dates as "05.22", when it means "22nd
May". It displays times as "01:15 pm".

I wish to plot my blood glucose levels, and would like to enter the dates
and times in the format shown on the instrument - either in one column or two
(date and time separate). Obviously, it would be nice to display dates in
the English format I am used to (22/5 instead of 5/22), but this is not so
important as being able to plot them. Is there any way I can persuade Excel
2003 to accept "05.22 01:15 pm", in one cell or two, and recognise these -
singly or in combination, as "22 May, 1.15 pm", so that I can create a chart
showing the correct date and time?

Signature

Peter

Reply to this Message

Stefi - 22 May 2008 15:06 GMT

For me Excel accepted "05.22 01:15 pm" and converted it to real Excel
date/time format. If so, simply format cells with this custom format code:
dd mmm h:mm AM/PM

Regards,
Stefi

„Peter Glebe” ezt írta:

> I have some experience of using Excel (2003), but cannot do anything other
> than very simple VBA. I have a piece of equipment (a blood glucose monitor),
[quoted text clipped - 9 lines]
> singly or in combination, as "22 May, 1.15 pm", so that I can create a chart
> showing the correct date and time?

Reply to this Message

Pete_UK - 22 May 2008 15:24 GMT

If you put your date/time exactly in that format in cell A1, this
formula in B1 will convert it into English format:

=(MID(A1,4,2)&"/"&LEFT(A1,2)&"/2008 "&RIGHT(A1,8))*1

Apply a custom format to the cell of:

dd mmm hh:mm AM/PM

which will then display 22 May 01:15 PM with your sample data. Copy it
down column B as required.

Hope this helps.

Pete

On May 22, 2:45 pm, Peter Glebe <PeterGl...@discussions.microsoft.com>
wrote:

> I have some experience of using Excel (2003), but cannot do anything other
> than very simple VBA. I have a piece of equipment (a blood glucose monitor),
[quoted text clipped - 12 lines]
> --
> Peter

Reply to this Message