Printing
That formula keeps returning an error
"Pete_UK" wrote:
Assume your values are in column F, then insert a new column G and
enter this formula in G2:
=IF(F222:00:00,"Close",F2)
Then copy this down. Put the same heading in G1 as you have in F1, then
you can hide column F - the rest of the worksheet will still access the
values in column F and so will be unaffected, but your time column will
now contain the word "Close" for any times after 10pm.
Hope this helps.
Pete
|