Hi,
We operate Mon-Fri 9:00 to 17:30, I have two fields called [Request date] which is the start and [Assigned date] which is the end.
I wish to compute the difference in minutes, however bearing in mind business days and hours mentioned above.
So, (probably not a good example)-if a ticket was raised at 5:40pm and it was assigned next day at 09:03, then it's 3 minutes instead of 900+ minutes.
Please help? Thanks.
We operate Mon-Fri 9:00 to 17:30, I have two fields called [Request date] which is the start and [Assigned date] which is the end.
I wish to compute the difference in minutes, however bearing in mind business days and hours mentioned above.
So, (probably not a good example)-if a ticket was raised at 5:40pm and it was assigned next day at 09:03, then it's 3 minutes instead of 900+ minutes.
Please help? Thanks.
