Date formats English/US

[Peter Glebe]

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?

 

[Stefi]

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:

 

[Pete_UK]

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