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
