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.