How to Calculate minutes between two date/time

[imrangaslam]

Hello

I need to calculate the total  no of minutes as per the below two tables for each customer.

BPVD026501	10/12/2020 5:14:29 PM	12/1/2020 5:11:23 PM
BPVS219401	10/28/2020 1:24:13 PM	12/4/2020 6:06:33 PM
BPVT310801	11/2/2020 2:13:50 PM	12/29/2020 4:49:26 PM
BPVT408201	11/2/2020 2:15:29 PM	12/7/2020 3:18:24 PM

Things to remember:

Working Days only (From Monday to Friday)

And working time onlye (From 08:00 am to 17:00)

Please advice how to do this task.

Many taks for every one.

[amitchandak]

@imrangaslam , there are a couple of video around that, see those can help

https://www.youtube.com/watch?v=_O8o6Hxuyjk

https://www.youtube.com/watch?v=GLIoDbOiJgw