Timestamp difference in working hours

[#1]

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

[Anonymous]

Follow this

Work minutes

[buzzy996]

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.

[maxgro]

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)

[#5]

Thanks to all but how should I write script