In B1 enter:

=IF(A1="M",NOW(),"") and format as time

then copy B1 downwards.
--
Gary''s Student - gsnu200823


"Shaun" wrote:

I require a FORMULAE for example if i enter "M" in A1 cell then the B1 cell
should display the current time, like this the current time should appear in
B2 cell when i enter "M" in A2 cell.

Example
A1 B1
M 10:53:45

A2 B2
M 10:53:55

Any help on this?

Thanks.