DIFF

[master_student]

Hello Guys,

I need your help, I need to get the difference between two date that have that format :

Creation date 22/10/2017 12:33:35

Last modification date 23/10/2017 08:01:41

I need to get the result in hours : minitues without counting sundays

Thanks

[its_anandrjs]

Try Interval match function

if( NOT Match(Weekday([Last modification date]),'Sun') and NOT Match(Weekday([Creation date]),'Sun') ,

Interval([Last modification date] - [Creation date] , 'mm')) as Difference