It is sheet event code. I just tested with both 2003 and 2007 and they
both
came up the same way as
1:35:00 AM or 01:35 depending on the format you choose
Did you put the code in the sheet (right click the sheet tab and select
view
code and paste in the macro there,
then change this part
If Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
to the range you want it to cover
Then close the VBA editor (alt + Q)
save the workbook and start typing
--
Regards,
Peo Sjoblom
I appreciate the fast response and as this is required on a daily basis,
this
is the best way I think. However, I am struggling with it.
I use Excel 2007 so not sure if this makes a difference. I changed the
range initially to match where I will be entering the data, but it is
not
working. E.g. if I type 135 in a cell, it shows 3240:00 instead of
1:35.
The
cell is formatted as [h]:mm.
What am I doing wrong?
:
If you want to do this on a regular basis you would be better off
using
an
event macro
http://www.cpearson.com/excel/DateTimeEntry.htm
--
Regards,
Peo Sjoblom
Hi
I would like to enter time into a timesheet using the decimal point
instead
of the colon as it makes it easier and quicker to type, however I
still
want
it to display correctly with the colon.
For example - if I enter 12.35 I would like it to display as 12:35
so
it
is
literally just changing the . to :
Many thanks in advance.