Exceeding Max Visit Duration

Question

Good day All

Please can you assist.

Below is visit data from one of our Sales Reps. The Rep forgot to log out of the call. The Max allowed duration is 2hours per call.

Acc no.Acc Name Visit No.Start TimeEnd TimeDuration 112233ABC StoreV00012022/06/28 11:002022/06/28 14:00180445566XYZ StoreV00022022/06/28 14:502022/06/28 15:3040100025Happy barV00032022/06/28 16:002022/06/29 02:00600

Please help me get to below result.

Acc no.Acc Name Visit No.Start TimeEnd TimeDuration End Time (Adjust for Max Duration)Duration Adj112233ABC StoreV00012022/06/28 11:002022/06/28 14:001802022/06/28 13:00120445566XYZ StoreV00022022/06/28 14:502022/06/28 15:30402022/06/28 15:3040100025Happy barV00032022/06/28 16:002022/06/29 02:006002022/06/28 18:00120

binu_acs · Answer

@Grantham one way of doing this

Exceed_11_07.yxmd

grazitti_sapna · Answer

@Grantham, another way of solving this problem.

Thanks!

Grantham_workflow.yxmd

Emmanuel_G · Answer

Hi @Grantham ,

Find a really simple test to use with exact desired output.

Let us know if it works as you want.

Cheers !

Max duration.yxmd