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