Mashzone timespan calculation (without week-end days)

Hello Mijo,

it is relatively easy to calculate the difference between 2 dates, you have only to convert this into milliseconds and then you can subtracting  one date by the other. Now you have only convert milliseconds to seconds, hours or whatever you want.

But I don't know a way to do this without week-end days.

Best regards,

Bernd

Hello Mijo,

There is my solution using oracle database.

Import the attachment file and configure the data source for oracle.

Best regards,