Dates Diff

[master_student]

hello Guys,

I hope all is well.

I need to get the difference between two date fields in hours: minutes that have this format : 'DD/MM/YYYY hh:mm:ss' without counting saturday and sundays. My actual expression :

(NetWorkDays([ROW_ADDED_DTTM],   [ROW_LASTMANT_DTTM]))

gives this result :

I need the result in hours knowing that the working hours are from 8h=>18h

so the result would be : 8H44 =>18h + 8h=>10:04

Any idea pleaase

Thanks in advance

[sunny_talwar]

May be check this

Business Working Hours Calculation

[master_student]

Hello Sunny,

Thanks for the link, i used the first script

1) Calculate business working hours excluding week ends(Saturday and Sunday) and Holidays.

but the result seems wrong. attached is my script (in the first conversation)

[sunny_talwar]

Let's see if kush141087‌ is available to help as he is the one who created the blog. He might be able to resolve this much better then I can.

[master_student]

Thanks for your help.