Thanks Pat Another Question

[davedynamic]

After thinking some more how do i tell the software that if the time goes over 4.00 pm to go to the next day at 7.30 am and continue to calculate the end date?

 

[Pat Hartman]

I don't really know how to answer because I don't have a good understanding of where you're headed with this. Date fields ALWAYS contain a time of day component in addition to the date. When you enter a date with no associated time, the time is assumed to be midnight. So, relating to your previous post, adding some number of minutes to that is probably not going to work for you. If 8.5 hours is equal to a day, you should probably divide the estimated number of minutes by 510 and add full days to the start date. Then store the remaining minutes in a separate field.

 

[raskew]

There appears to be some other factors that need to be considered:
Unless yours is a 24/7 operation,
What time does the workday start?
What time does the workday end?
Is there a lunch break and/or other breaks in the workday? If so, we need to know those times.
Do you work Saturdays?
Do you work Sundays?
Is a new job always going to begin at the start of the workday? If not, then each job will require a start time.

Given that information, it shouldn't be too difficult to arrive at an algorithm.