How To Remove The Error Value Returned By Formula Using IFERROR function

[peter renton]

I have attached a sample sheet which i have two questions on

How can i get rid of the #value from the sheet? the column deducts the current time from the time required by in column v
but i comes back with the #value until data is entered.(the time i column v is picked up from the time required column which is not the time just a way to enter four numbers to look like time)

Secondly the actual time clock is in A1 activated by ctrl+c. is there a way to have this auto start on active sheet (without the curser pulsing)


Regards


Peter