|Keeps sending back message about the formula.|
Error messages are always good to know, tells us what's not happening.
With your TIME in cell A1
and your New Value in B1
in cell C1 enter:
See how that works.