Current time

chrissy · Apr 4th, 2002, 07:16 PM

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.

Thankyou for your help.

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

Paul B · Apr 4th, 2002, 07:21 PM

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

chrissy · Apr 4th, 2002, 07:23 PM

Thanking you Paul B.

Works a treat!

chrissy · Apr 4th, 2002, 08:00 PM

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.

Yogi Anand · Apr 4th, 2002, 10:27 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 07:16 PM	#1
chrissy New Member Join Date: Apr 2002 Posts: 3	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. Thankyou for your help. [ This Message was edited by: chrissy on 2002-04-04 18:18 ]

Apr 4th, 2002, 07:21 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	=now() format cell as time to show secs.

Apr 4th, 2002, 07:23 PM	#3
chrissy New Member Join Date: Apr 2002 Posts: 3	Thanking you Paul B. Works a treat!

Apr 4th, 2002, 08:00 PM	#4
chrissy New Member Join Date: Apr 2002 Posts: 3	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.