calculate time (1 Viewer)

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!

You are going to want to use DateAdd (https://www.techonthenet.com/access/functions/date/dateadd.php). However, you can't use fractional hours. Which means you must convert your hours to minutes and use that.

Add to this the warning that if your "standard time to complete" is greater than 8 hours then you will have some interesting issues saying that the job will be complete "tomorrow at 10:30" if it started today at 9:30 and takes 9 hours (and your work shift doesn't run 9 hours long).