Convert time on pivot table

[askyy]

hey guys,

I have a pivot table with one column that has data like this:

14/04/2016 09:15
14/04/2016 10:15
14/04/2016 14:41
14/04/2016 15:46
14/04/2016 15:51
14/04/2016 15:54
14/04/2016 15:59
14/04/2016 15:59
14/04/2016 16:04
14/04/2016 16:06
14/04/2016 16:27
14/04/2016 16:33
14/04/2016 16:38
14/04/2016 16:46
14/04/2016 16:52
The problem is the time is currently GMT, and I want to change this to GMT+1. Can you help me?

[Toonies]

this may help

http://www.tushar-mehta.com/excel/timezone.htm

[stasinek]

You can will use this solution