szqz_531 Tracker

Re: Calculate Date and Time difference considering the weekends and workhours

szqz_531 — Thu, 01 Mar 2018 10:06:11 GMT

@dcs136 can you also look at my problem? have you occured this before?

Re: Calculate Date and Time difference considering the weekends and workhours

szqz_531 — Thu, 01 Mar 2018 10:05:00 GMT

Hello Herbert,

I am looking at your solution, but can you have a look at my data? The FirstDaySecDiff, LastDaySecDiff and MidDaysSecDiff are too large to be normal. I have no idea where is wrong. Thanks!!!

How to consider working hour in time different

szqz_531 — Thu, 01 Mar 2018 08:21:55 GMT

I need to calcualte two datetime stamp difference with the working hour consideration.

I have extracted the time (field name: TMS[Arrived_time]) from the datetime stamp,like:

16:40:00, 08:00:00, ,,,,,,,

working hour start at 08:30:00, end at 23:00:00

but when i write the fuction like below:

If_working_hour_flag_arrived = if(and(TMS[Arrived_time]>=TMS[Working_hour_Start],TMS[Arrived_time]<=TMS[Working_hour_End]),1,0)

the result are all 0,

but for TMS[Arrived_time] =16:40:00, the result should be 1.

Anyone have some thoughts?