F
freddie74
hi there,
I would like to be able to select a cell and type a number in it from 1-9.
When the number is entered i would like excel to record the time in that
cell. ie if i type 5 in cell B9 it automatically records the current time ie
10:57 in B9. Note the 5 is replaced with the recorded time. This time also
has to be fixed and cannot be changed, when i click on the next cell. This is
to record start and finish times in sheet.
I would like to be able to select a cell and type a number in it from 1-9.
When the number is entered i would like excel to record the time in that
cell. ie if i type 5 in cell B9 it automatically records the current time ie
10:57 in B9. Note the 5 is replaced with the recorded time. This time also
has to be fixed and cannot be changed, when i click on the next cell. This is
to record start and finish times in sheet.