world clock in excel

[thecueball]

Guys n' gals,

Is there a way to turn excel into a world clock?????

I am working for a company that has offices around the world, and I would like to see the time in all offices, when I am working in excel without using the internet (or spending monay on loads of wall clocks!!)

TIA

CB

 

[tactps]

Try:

=IF($H$5<TIME(2,0,0),24,0)+$H$5-TIME(2,0,0)

This will add 24 hours if now() < 2am.

 

[karthik1407]

WORLD CLOCK IN EXCEL WITH DAYLIGHT SAVING TIME

http://www.2shared.com/document/6Og5uHZu/World_Clock.html

 

[karthik1407]

Guys n' gals,

Is there a way to turn excel into a world clock?????

I am working for a company that has offices around the world, and I would like to see the time in all offices, when I am working in excel without using the internet (or spending monay on loads of wall clocks!!)

TIA

CB

WORLD CLOCK IN EXCEL WITH DAYLIGHT SAVING TIME


http://www.2shared.com/document/6Og5uHZu/World_Clock.html

 

[karthik1407]

world clock in excel



Download Excel

http://www.2shared.com/document/6Og5uHZu/World_Clock.html

 

[fernandotinoco]

It is possible to reach a solution that automatically consider daylight saving time in all time zones?

 

[Davo2079]

The error I received is the Negative Dates or Times Are Displayed as #####, when the time in H5 is 1 AM (01:00) and =$H$5+TIME(-2,0,0) is used.

Sorry, this is way too late to help you but it may help others who come across this problem.

If you enter

18/03/2017  1:30:00 AM

for example, into H5 and in I5 enter

=H5-TIME(6,0,0)

you will have the result 17/03/2017 7:30:00 PM

Then if you only want to see the hours and minutes, just do a custom format such as

  h:mm AM/PM

or however you want to view it.