Thanks:  0
Likes:  0

# Thread: Calculatinig timezone clock times

1. 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 A B C D 1 Call Time Time Diff +/- Zone Time 2 3 :alert('37381.75')>5/5/2002 18:00 20 :alert('37382.5833333333')>5/6/2002 14:00 4 5 =IF(B3>0,A3+TIME(B3,0,0),A3-TIME(ABS(B3),0,0)) 6 This 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. 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. 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. 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!

## User Tag List

#### Posting Permissions

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