We have a manufacturing company. I have a report that shows me when a job starts. Each job is different some take minutes and some take hours/days. If we worked 24 hrs per day my report would work, however we only work 10 hrs per day, starting @ 08:00.
On my report if the job starts on 14th March 2015 @ 08:00 and takes 15 hrs the job would finish on 14th March 2015 @ 23:00, the job would not actually finish 'til 15th March 2015 @ 13:00.
Hope this makes sense and I hope somebody can help.

So the working hours are from 8 am to 6 pm correct? How is the duration of the job stored?

-Dell

Cool, that makes things easier.

The period from 8 am to 6 pm is 10 hours which is 600 minutes. There are 1440 minutes in 24 hours. So, assuming that the start time is stored as a DateTime, here's what I would try:[code]
DateTimeVar result := {MyTable.Start_Date};
NumberVar workingMinutes := 0;
NumberVar lastMinutes := 0;
NumberVar i := 0;
NumberVar firstMinutes := DateDiff('n', {MyTable.Start_Date}, DateTime(Year({MyTable.Start_Date}), Month({MyTable.Start_Date}), Day({MyTable.Start_Date}), 18, 0,0);

if (firstMinutes > {MyTable.Duration}) then
workingMinutes := {MyTable.Duration};
else
(
lastMinutes := {MyTable.Duration} - firstMinutes;
i := lastMinutes \ 600; //Note that this is '\' which is "integer divide"
workingMinutes := firstMinutes + (i*1440);
i := lastMinutes mod(600); //number of remaining minutes
workingMinutes := workingMinutes + i;
)
DateAdd('n', workingMinutes, {MyTable.Start_date}

I don't guarantee that the syntax is correct, so you might have to tweak a few things, but the logic should be good.

-Dell