Hi
Im really stumped. Im trying to calculate the differences between 2 dates with variable hours for each day and round up out of hours times up to the next working time.
For example
Monday - Friday working hours are 07:00 to 18:00
Saturday working hours are 07:00 to 12:00
If a request is made at 09:00 on monday and completed at 15:00 on the same day that fine, but if the request is made at 18:01 on Monday and not completed until 07:30 on Tuesday, I need the time of 18:01 to be rounded up to the next day starting at 07:00.
Also throwing into this the different hours for Saturday as some requests can be put in at 07:00 on Monday and not be completed until 07:00 the following Monday so i need it to take into account the the hours specified for each day and exclude Sundays whilst rounding up anything necessary to the next day.
Help please!!!
Im really stumped. Im trying to calculate the differences between 2 dates with variable hours for each day and round up out of hours times up to the next working time.
For example
Monday - Friday working hours are 07:00 to 18:00
Saturday working hours are 07:00 to 12:00
If a request is made at 09:00 on monday and completed at 15:00 on the same day that fine, but if the request is made at 18:01 on Monday and not completed until 07:30 on Tuesday, I need the time of 18:01 to be rounded up to the next day starting at 07:00.
Also throwing into this the different hours for Saturday as some requests can be put in at 07:00 on Monday and not be completed until 07:00 the following Monday so i need it to take into account the the hours specified for each day and exclude Sundays whilst rounding up anything necessary to the next day.
Help please!!!
