Time taken to close call logic

[hopkinsc]

Hi All,

I need some help with the following if possible please?

I need to find the Time to Close time.

I have a Call Open timestamp and a Call Close timstamp and i need to fine the difference beween them to give me the time taken to resolve the call.

But it gets a bit tricky as the working day is between 9-5, so if a call is opened on Tuesday at 10am and closed on Wednesday at 11am then the time would be:

Tues 10am to Tues 5pm = 7hrs

Wed 9am to 11am = 2hrs

Total time taken = 9hrs

I have attached a sample.

Thanks

[hopkinsc]

Hi again, i have holiday times also (Dates and times) stored in a variable (vBankHols), how would i take them into account also.

Sorry about all the questions.

[#3]

Hi, Saw this post very useful. when calculating hours if the create time is less than the close time then the below function is not calculating properly.

(Timestamp#([Closed WorkingDateTime],'DD/MM/YYYY hh:mm')

  - Timestamp#([Create WorkingDateTime],'DD/MM/YYYY hh:mm'))*24

- 16 * (day(Timestamp#([Closed WorkingDateTime],'DD/MM/YYYY hh:mm'))

                  - day(Timestamp#([Create WorkingDateTime],'DD/MM/YYYY hh:mm')))

Example

Createtime 10/09/2012 22:05

Received time 11/09/2012 09:15

then the result is -4.833333

Please help