Current time

chrissy

New Member
Joined
Apr 3, 2002
Messages
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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top