A
albertmb
Hi Everyone, I have a problem and I hope someone will find a solution for me.
In cell A1 I have =Today()
in cell B1 I have a cde that gives me the time in real time
From cells E6:E369 I have a calendar
From Cells H6:H369 I wrote this formula,
IF(ISNA(VLOOKUP(E6,$A$1:$B$1,2,FALSE)),0,VLOOKUP(E6,$A$1:$B$1,2,FALSE))
This gives me a '0' where the date does not match and the time where the
date matches.
Is there a way of how I can keep the time in the matching cell without
changing (i.e. stoping the clock in the relevant cell) and keep the result
even when the date changes the next day.
Thank you for all you do with us who want alot and know little.
Regards
Albert
In cell A1 I have =Today()
in cell B1 I have a cde that gives me the time in real time
From cells E6:E369 I have a calendar
From Cells H6:H369 I wrote this formula,
IF(ISNA(VLOOKUP(E6,$A$1:$B$1,2,FALSE)),0,VLOOKUP(E6,$A$1:$B$1,2,FALSE))
This gives me a '0' where the date does not match and the time where the
date matches.
Is there a way of how I can keep the time in the matching cell without
changing (i.e. stoping the clock in the relevant cell) and keep the result
even when the date changes the next day.
Thank you for all you do with us who want alot and know little.
Regards
Albert