Timer or Watch

[akinkaraman]

Is it posiple to make analog or digital clock in a sheet?

 

[NARAYANK991]

Hi ,

See if this is what you are looking for :

http://excelunusual.com/making-a-clock-in-excel/

Narayan

 

[NARAYANK991]

Hi ,

Yet another link :

http://www.mrexcel.com/forum/excel-...isplayed-over-worksheet-made-purely-apis.html

Narayan

 

[akinkaraman]

Hi Narayan, thank you for sources. I've just forgotten to tell that I needed a clock which shows the time in GMT zone.

 

[Somendra Misra]

Hi Akin,

Why not convert your local time to GMT and than this play it on the clock?

Regards,

 

[akinkaraman]

Hi Somendra..

It is a nice idea but I will use my sheet in the aircraft's computers and I don't want to change the time of it.

What I need is a clock which shows the time in GMT zone and also in local time's zone at the same time. We are writing times in GMT and following works in local time.

So I thought maybe I can have a clock in my sheet that I could change from Gmt to local time with a click when I need at working on my sheet and it would be very time saver for me. Because we are working against to time.

 

[Somendra Misra]

Hi Somendra..

It is a nice idea but I will use my sheet in the aircraft's computers and I don't want to change the time of it.

What I need is a clock which shows the time in GMT zone and also in local time's zone at the same time. We are writing times in GMT and following works in local time.

So I thought maybe I can have a clock in my sheet that I could change from Gmt to local time with a click when I need at working on my sheet and it would be very time saver for me. Because we are working against to time.

Can you tell me your time zone so that I can show you how to do this.

Regards,

 

[akinkaraman]

I live in Turkey. Now 16:28 (Gmt + 2)

 

[Somendra Misra]

See this file to convert time from your time zone to GMT time zone this can be used in your file.

Regards,

 

[akinkaraman]

Thank you Somendra, I will figure out with that formula how to get a dynamic clock.

 

[Somendra Misra]

The first link posted by @NARAYANK991 Sir update local time in a cell by using VBA, than you can put the formula in other cell and use it to make clock.

Regards,

 

[akinkaraman]

I need some help. In my sheet what formula should I write into D3 and D4

and also how can I modify the macro to auto run.

It is working only when I run the macro. I want it to run automatically.

I don't know how to do. Can you help me?

 

[Somendra Misra]

@akinkaraman

I did not understood your requirement in D3 & D4?

Regards,

 

[akinkaraman]

If we think that A3 is a GMT time;
D3 will be GMT time (A3) + 5 Hours and
D4 will be GMT time - 2 Hours

 

[Somendra Misra]

See this file. But you must consider date + time as this is a zone conversion and time will be affected.

Regards,

 

[akinkaraman]

Thank you Somendra. Super..

Do you know the solution of my second question?
The macro works when I run it. How can I make it to work automatically without running it manually?

 

[Somendra Misra]

Well if you see the code on the sample file on below link, you can see that you can start and stop the macro with a single button. Hope this will be useful to you.

http://excelunusual.com/making-a-clock-in-excel/

Regards,

 

[akinkaraman]

I wrote a code under "ThisWorkbook" and now the macro is running automatically.

Thanks for helps. I am learning with your great helps.

Private Sub Workbook_Open()
Call Start_Timer_with_Macro
End Sub