Time Functions

  • Thread starter Thread starter Caz
  • Start date Start date
C

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.
 
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.
 
Thanks Paul, that works fine.


Paul said:
This will enter the current system time in a cell, but not have it
update:
Click to expand...
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.



Caz;689947 said:
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.
Click to expand...


--
Paul

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

http://www.thecodecage.com/forumz

.
Click to expand...
 
Back
Top