Hi,

To get a 'static' time in a cell hold down CTRL + Shift and tap ;

Doing this at the start and then end of the task would give you the times.
Calculation of the duration is done by subtraction

Start in a1
End in a2

=A2-A1

For the duration
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Caz" wrote:

Hi,

I am trying to set up a timesheet whereby I can put in the start time and
end time of the job and get it to calculate the amount of time spent on the
job.

a) Is there anything I can put in a cell that would get it to read the time
from the computers clock (and not update as time goes by)

b) Is there a function available that would calculate how long I have spent
on the job.

Thanks in advance.