need calculation of days,hour & min

[#1]

hey guys ,

I need to calculate the no of working days (excluding the weekends) , hours and minutes to close the case for the following table.

for null filed it will take system time.

Please help

[ThornOfCrowns]

To find the number of working days, use:

networkdays

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

example:
networkdays (startdate, enddate, holidaydate1, holidaydate2,holidaydate3,holidaydate4.......)

[MK_QSL]

Re: Network Days

[#4]

but for the last one it will not work?

[mato32188]

Hello Amit,

see attached file. Hope it helps.

BR

M

[#6]

i am not seeing any attached file martin

[mato32188]

-►