Thanks:  0
Likes:  0

1. Hi guys,

This is probably a simple question, but I havent been able to find the function to insert.

I need a cell to display the current time, to seconds, based on the system clock. Then in another cell, take a certain number of hours off (or added to) this time, to provide the correct time in another timezone.

I searched through previous posts but was unable to find what I am after.

[ This Message was edited by: chrissy on 2002-04-04 18:18 ]

2. =now() format cell as time to show secs.

3. Thanking you Paul B.

Works a treat!

4. Sorry Guys,

I know this is a major no-no, to post a question and then add another part to the problem, but here I go. Forgive me.

How can I work out how many hours until a time the following day? For example, if the time is 9:00 p.m. and I want to know how many hours it is until 6:00 p.m. tomorrow. I cant seem to work out how to not arrive at the answer 3! I have tried adding a day, but when the current time is 1:00 a.m. using this method will be incorrect.

Thankyou again guys.

5. On 2002-04-04 19:00, chrissy wrote:
Sorry Guys,

I know this is a major no-no, to post a question and then add another part to the problem, but here I go. Forgive me.

How can I work out how many hours until a time the following day? For example, if the time is 9:00 p.m. and I want to know how many hours it is until 6:00 p.m. tomorrow. I cant seem to work out how to not arrive at the answer 3! I have tried adding a day, but when the current time is 1:00 a.m. using this method will be incorrect.

Thankyou again guys.
Hi Chrissy:

in cell E10 ... 4/4/02 9:00 pm
in cell F10 ... 4/5/02 6:00 pm

then in cell G10, put the formula =F10-E10

and FORMAT|CELLS|CUSTOM [h:mm:ss
result should be 21:00:00

## 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
•