Hi Everyone, I have a problem in Microsoft Excel and I hope someone will find a solution for me.

In cell A1 I have =Today()
in cell B1 I have a code 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(E 6,$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. stopping the clock in the relevant cell) and keep the result even when the date changes the next day.

Thank you
Albert