At the moment i have been using long if statements to keep the work times of jobs within the working day.
I was wondering if there is some vba code which would allow me to set the hours of my work day and then when the job time is added to my start time only stay within my set times and carry on the next morning.
The if statements i have been using are fine for jobs that only run for the day or into the next but anymore than that and it starts to go wrong
Any help would be greatly appreciated
Thank you
I was wondering if there is some vba code which would allow me to set the hours of my work day and then when the job time is added to my start time only stay within my set times and carry on the next morning.
The if statements i have been using are fine for jobs that only run for the day or into the next but anymore than that and it starts to go wrong
Any help would be greatly appreciated
Thank you
