Hey all - I'm hoping you can help. I have a table with a column called "StdHours" (for Standard Hours). It's a decimal field. It holds the standard hours for job completion.
For example, job1 should take "1.5" StdHours and job2 should take "2.25" StdHours to complete.
What I'd like to do is add the "StdHours" to a "start time" that gets entered when run (which I've formatted for Short Time) so that if "8:00" is entered for the "start time", I get a result of "9:30" for job1 completion and "10:15" for job2 completion.
Let me know if you need more info. Thanks!
For example, job1 should take "1.5" StdHours and job2 should take "2.25" StdHours to complete.
What I'd like to do is add the "StdHours" to a "start time" that gets entered when run (which I've formatted for Short Time) so that if "8:00" is entered for the "start time", I get a result of "9:30" for job1 completion and "10:15" for job2 completion.
Let me know if you need more info. Thanks!