Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Calculatinig timezone clock times

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe this will help.

    Microsoft Excel - Book1
    File(F) Edit(E) View(V) Insert(I) Options(O) Tools(T) Data(D) Window(W) Help(H)
    C3=37382.5833333333
    ABCD
    1Call TimeTime Diff +/-Zone Time
    2
    3:alert('37381.75')>5/5/2002 18:0020:alert('37382.5833333333')>5/6/2002 14:00
    4
    5=IF(B3>0,A3+TIME(B3,0,0),A3-TIME(ABS(B3),0,0))
    6This formula goes into cell C3
    7
    Sheet1

    You can see the formula of cells only click each above hyperlinks

    The above image was automatically written by HtmlMakerVer1.12
    If you want this code, click here and Colo will email the file to you. Thanks to Colo for this code.>



    Tom

    [ This Message was edited by: TsTom on 2002-05-13 04:32 ]

  2. #12
    New Member
    Join Date
    May 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this partially works, apart from the cells where the time difference means the new call time is the previous day, it does not seem to like anything before 9am with a 9 hour difference.


  3. #13
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I put this in cell A1 (this really should work):
    12/12/02 8:00 AM

    in cell B1:
    -9

    in cell C1:
    =+A1+B1/24

    Cell C1 displays:
    12/11/02 11:00 PM

    I can't get this not to work for any time period,

    Good Luck!
    Corticus

  4. #14
    New Member
    Join Date
    May 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi thanks for the help, it seems to be working. The problem was that the times were already entered and the format for date was sitting at the one with am/pm after the time. Hopefully we can use this to our benefit. Thaks to all great idea for helping and passing the knowledge. anyone advise moving to 97/2000 to office XP!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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