S
Steved
Hello from Steved
How do I format a worksheet so that when I type 844
it becomes 08:44 (hh:mm)
Thankyou
How do I format a worksheet so that when I type 844
it becomes 08:44 (hh:mm)
Thankyou
F
Frank Kabel
Hi
you need VBA for this (using an event procedure). See
http://www.cpearson.com/excel/DateTimeEntry.htm
you need VBA for this (using an event procedure). See
http://www.cpearson.com/excel/DateTimeEntry.htm
B
Bob Phillips
You don't. 844 is a number. You could put this in another column
=TIME(INT(A6/100),A6-INT(A6/100)*100,0)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
=TIME(INT(A6/100),A6-INT(A6/100)*100,0)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
B
Bob Phillips
QTE?
Frank Kabel said:
S
Steved
Thankyou Gentlemen
F
Frank Kabel
Bob said:
Thought about that too but I think Chip's solution for this is quite
sufficient. (Nearly) all countries have a hh:mm format (even
Australia...)
Frank