HI Guys,
I came across an example from this forum, which I'm using but I think it got some bugs, I hope that someone can help. Attached is the file.
There is a modual for this, i'm trying to calculate the time between the Open Date and Close Date columns, it works for some dates but not for the other, please take a look at it. Go to Queries and run the query, thanks.
I'm trying to get the total minutes, there is a start shift and end shift, there is also a holiday table, this module also excludes saturday and sunday.
I came across an example from this forum, which I'm using but I think it got some bugs, I hope that someone can help. Attached is the file.
There is a modual for this, i'm trying to calculate the time between the Open Date and Close Date columns, it works for some dates but not for the other, please take a look at it. Go to Queries and run the query, thanks.
I'm trying to get the total minutes, there is a start shift and end shift, there is also a holiday table, this module also excludes saturday and sunday.
Attachments
Last edited: