Dear Users,

I am trying to calculate the working hours in a local timezone that it takes for my support teams to respond to our customerbase. I have the GMT times for question posted, the GMT times for a response, the number of hours it took to respond and the country of origin. I think this is enough to start.

So far, I have created a lookup table to correct the times based on country of origin to ensure they are local and from this point I have got stuck. I have derived the time correction, no problem, but I cannot make the adjustment to the times stored and this is my question.

The date/time formats are dd/mm/yyyy hh:mm and my correction is in decimal hours, ie. +2 or -7.

What formulae do I need to change the time by the appropriate hours and then get back to dd/mm/yyyy hh:mm?

Your help would be much appreciated.

Regards

Paul.