Time Functions

[Caz]

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.

 

[Mike H]

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.

 

[Paul]

This will enter the current system time in a cell, but not have i
update:
CTRL + SHIFT + :

You should be able to just use subtraction to find out how long spen
on the job. If Start time is in A1 and End time is in A2, use:

=A2-A1

and format as time (h:mm or [h]:mm if it goes over 24 hours).

You could also use

=NOW()-A1

if you don't have an End time cell.

 

[Caz]

Hi Mike,

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

Caroline

 

[Rick Rothstein]

Ctrl + Shift + {semi-colon key}

 

[Caz]

Thanks Paul, that works fine.

This will enter the current system time in a cell, but not have it
update:

CTRL + SHIFT + :

You should be able to just use subtraction to find out how long spent
on the job. If Start time is in A1 and End time is in A2, use:

=A2-A1

and format as time (h:mm or [h]:mm if it goes over 24 hours).

You could also use

=NOW()-A1

if you don't have an End time cell.

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.

--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192822

http://www.thecodecage.com/forumz

.