Time Calculation

  • Thread starter Thread starter PHisaw
  • Start date Start date
P

PHisaw

Hi,

I have a field that has total time spent on job and now boss wants a
"countdown" of time left to finish job. If I have a number type field for
hours given to complete job, how can I work a calculation to subtract the
time spent (which is a date/time field) from the hours given so that each
time a tech signs on to said job the time left to complete job appears in
field?

Any help is greatly appreciated.
Thanks,
Phisaw
 
sound like you dont like you boss comming up with NEW ideas

create a text box and then give it a rowsource of

"select hoursttocomplete - sum(timespent) from jobtable,workdonetable
where jobtable.jobid = workdonttable.jodtid"

hope this helps

Regards
Kelvan
 
Kelvan,

Thank you for replying, but I don't quite understand your solution. I have
a table tGeneralInfo with a number field "TotalRepairHours" where number of
hours required to complete job should be entered. I have another table
tWorkLog with date/time fields StartTime and StopTime which are on a form
fTimeSheet with DateDiff calculation to give time worked for each record. I
also have a field "SummedHoursMinutes" which gives total time worked for each
job. The form fTimeSheet is a subform on the form fGeneralInfo and is
related by job number.

This being said all calculates and links together as it should. I think the
problem is how to subtract "SummedHoursMinutes" which is a date/time field
from "TotalRepairHours" which is a number field.

If you can further explain how I can use your solution or have any other
ideas, I would appreciate it.
Thanks again,
Phisaw
 
Back
Top