Time Calculation

[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

 

[Lord Kelvan]

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

 

[Marshall Barton]

create a text box and then give it a rowsource of

Getting tired?

... textbox ... rowsource ...

or did I miss a new feature?
;-)

 

[PHisaw]

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

 

[PHisaw]

I have solved the problem. Thanks for your time.

 

[Lord Kelvan]

what o sorry yeah long day on friday i been staring at list boxes all
day