altering web query date by one hour

Hi

The website I import my data from is an hour behind my time zone and I need to alter this if I can. I import the data on to one sheet and I need to manipulate the time on to another sheet albeit an hour later so eg 14:30 becomes 15:30. Can I do this with a simple formula?

Thanks in advance

If A1 is the time input cell (change as required), try:

=A1+TIME(1,0,0)

or,

=A1+1/24

Yep that will do it. The first formula works a treat.

Many many thanks.