Hi,
I'm completely new to Excel and need a bit of help, be gentle . I need to automatically work out 3 different time zones from entering one GMT time.
I would have three columns named GMT, BST and CEST, I would like to enter a time, say 07:00 into the GMT column and then have excel to automatically place the other two, which would be 08:00 and 10:00.
At this time of year BST (British Summer Time) is +1 hour, and CEST (Central European Time) is +2 hour.
Any help would be great.
Stevo
Bookmarks