Time Functions
 

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.

Time Functions
 

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.

Time Functions
 

Hi Mike,

I have tried the Ctrl + Shift + tap and nothing happens.

Caroline


"Mike H" wrote:

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.

Time Functions
 

Ctrl + Shift + {semi-colon key}

--
Rick (MVP - Excel)



"Caz" wrote in message
...

Hi Mike,

I have tried the Ctrl + Shift + tap and nothing happens.

Caroline


"Mike H" wrote:

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.