Real Time Clock in Cell

**phillija** · 04-27-2010, 01:25 PM

Hello,

I would like to have the current time listed on a worksheet in a certain cell (B27). I have used the code "=now()" but then the only way for me update the time is to hit the F9 key and re-calculate the cell. I would like the time to update automatically so I can write some if statements based on the time in cell B27.

I have been looking around elsewhere and it seems like the only way to do it is by writing a macro. I have very limited macro experience so I have struggled to get this to work. If someone could help me out I would appreciate it!

Thank you in advance.

Jake

**royUK** · 04-27-2010, 01:47 PM

This is one way

**phillija** · 04-27-2010, 02:02 PM

That worked well, I made a couple small changes to the code but got it work. Thank you so much for the help and the quick response!

Jake

**royUK** · 04-27-2010, 02:07 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save