topic Timestamp difference in working hours in QlikView

Timestamp difference in working hours

Mon, 16 Mar 2015 12:00:22 GMT

Hi,

I have two timestamp fields as below. I need to calculate the difference of these two in working hours i.e. between Monday to Friday and 9am to 5pm. Also excluding public holidays

Entered	Analysed	Working Hours
13/03/2015 10:00:00	16/03/2015 11:00:00	9
16/03/2015 10:00:00	16/03/2015 12:00:00	2

Re: Timestamp difference in working hours

Anonymous — Mon, 16 Mar 2015 12:20:03 GMT

Follow this

Work minutes

Re: Timestamp difference in working hours

buzzy996 — Mon, 16 Mar 2015 12:21:37 GMT

try this,

=Interval(Interval(Sum(Analysed),'hh:mm:ss') - Interval(Sum(Entered),'hh:mm:ss'),'hh:mm:ss')

for excluding holidays, u have create on excel with all ur days and maintain the flag with 0(WORKING DAY) OR 1(HOLIDAY) AND IN SCRIPT LEVEL U HAVE SUBTRACT ALL UR HOLIDAYS.

Re: Timestamp difference in working hours

maxgro — Mon, 16 Mar 2015 12:22:52 GMT

just an idea

hour in Entered day (if not holiday)

+ (networkdays between entered+1 and Analysed-1) * 8

+ hour in Analysed day (if not holiday)

Re: Timestamp difference in working hours

Mon, 16 Mar 2015 12:29:47 GMT

Thanks to all but how should I write script