Refreshing Date or Now function

[dimitrz]

Hi Guys,

Dont know wether this is possible!
But is it possible to have a function/formula/macro so that I can have a cell display the current date and time.

I know its possible using

Please Login or Register  to view this content.

formula

however it does not get refreshed automatically - I want these cells to auto refresh with the current time say everyone hour or so.

The reason for this is I want to have a cloumn which show the correct number of days and time Lapsed since a request was created.

And these fileds will go Red if the day count is above 5 days.

Since there would be hundreds of rows added daily its not feasible to change each and every cell everday if you get my point

Thanks

Cross posted at http://www.mrexcel.com/forum/showthr...21#post1684421

[martindwilson]

have a look here
http://www.cpearson.com/excel/OnTime.aspx

your code
in the bit where it says enter your code should look like this

Please Login or Register  to view this content.

where a1 is the cell your time is to be

[dimitrz]

Thanks Martin,

just checkin g the link and the code you mentioned