+ Reply to Thread
Results 1 to 4 of 4

Newbie needs a bit of help with time

  1. #1
    Registered User
    Join Date
    05-06-2005
    Posts
    2

    Newbie needs a bit of help with time

    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

  2. #2
    Registered User
    Join Date
    05-03-2005
    Posts
    11

    Smile

    Steve,
    assuming your column headers are in the range A1:C1 and your times are in the range A2:C2
    enter in cell B2

    =A2+TIME(1,0,0)

    in cell C2 enter

    =A2+TIME(3,0,0)

    Regards, Stuart.

  3. #3
    Registered User
    Join Date
    05-06-2005
    Posts
    2
    Thanks for your help Stuart,

    Is it possible to make it 24h time. I would also like to have whatever I input into Column A2 - A20 automatically show in B2 - B20 and C2 - C20.

    For example

    I enter 14:00 in A5 and the appropriate times are entered in B5 and C5, then enter 21.35 in A10 and again the times are placed in B10 & C10. More of a universal calculation for 3 columns and 20 rows, this is for a timetable.

    Stevo

  4. #4
    Registered User
    Join Date
    05-03-2005
    Posts
    11
    Hi Steve,

    re 24hr result. format the formula I gave you as time 13:30:55 that should give you a 24hr result

    with regard to the rest, i would have thought that if you have formulas down the ranges B2-B20 & C2-C20 that should do the trick.

    stu

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1