Completion time

[Pushkar92]

I have an excel with 4 column.

1. Request received date

2. Request received time

3. Completion date 

4. Completion time

For every urgent request completion time is 5 hours.

We will have to focus on those urgent request which we receive between 9am to 6pm.

So I have to calculate time taken to complete any  urgent request which we receive taking the four points mentioned above. 

Need help in understanding how that can be done.

[atcodedog05]

Hi @Pushkar92 

Duration Hrs only

DateTimeDiff(
[Request Completion Date]+" "+[Request Completion Time],
[Request Received Date]+" "+[Request Received Time],
"hours")

Duration Mins only

DateTimeDiff(
[Request Completion Date]+" "+[Request Completion Time],
[Request Received Date]+" "+[Request Received Time],
"minutes") -
(DateTimeDiff(
[Request Completion Date]+" "+[Request Completion Time],
[Request Received Date]+" "+[Request Received Time],
"hours")*60)

Duration (Hrs)

[Duration Hrs only]
+[Duration Mins only]/100

Duration (Hrs)

IF DateTimeDiff([Request Completion Date],
[Request Received Date],"day")>0 
THEN [Duration (Hrs)]-15 ELSE [Duration (Hrs)] ENDIF

Snapshot:

What is the issue you are facing while opening?

Hope this helps : )