Enter time with . but display as :
Thank you for your prompt reply, however, I decided to use the vba code option.
Thanks again.
"Gary''s Student" wrote:
Another way, with 12.35 in A1, in B1 enter:
=--SUBSTITUTE(A1,".",":") and format B1 as Time.
--
Gary''s Student - gsnu200806
"harwookf" wrote:
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.
|