I will take a look t your file, but note that TIME is a volatile function that only updates with a worksheet/file change.