I have a start time stamps and end time stamp in my data. For example Start time stamp = 7/28/2016 1:20:00 PM and End time stamp = 7/29/2016 7:30:00 PM and working hours are 8 AM to 5 PM. I want to extract difference in time stamp for each day like according to given example output should be
| Start tijme stamp | End time stamp |
| 7/28/2016 13:20 | 7/28/2016 17:00 |
| 7/29/2016 8:00 | 7/29/2016 17:00 |
| |
I am using
Date(StartDate+iterno()-1) as StartDate_update
resident MACHINE
while
Date(StartDate+IterNo()-1) <= Date(EndDate);
But it only extract the dates, I have to take care of working hours and weekends also . Any one any idea how should I solve this problems
