I am facing problem to count workingtimes from StartDate to EndDate where the office hour from Time_Start='08:45:00' to Time_End='17:45:00'. I already try using the solution provided on others discussion in this forum but still not resolved.
Hope I can get the correct way on how to compute the WorkTimes below: -
a. Period from StartDate to EndDate;
b. Exclude Holiday;
c. time range is actual time from StartDate to EndDate between 08:45:00 - 17:45:00;
1. if StartDate or EndDate is less than 08:45:00, the time to be counted as 08:45:00;
2. if StartDate or EndDate is more than 05:45:00, the time to be counted as 05:45:00;
3. else to use the actual time for StartDate or EndDate;
4. for the date between StartDate and EndDate to be used time as 08:45:00 till 05:45:00 (9hours) - exclude Public Holiday.