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

[Excel Fox]

You can use K6=IFERROR(V6-A$1,"") and drag the formula down

For the second query, why don't you just use the NOW() function to give you the latest time as it is volatile. You must know that this calculates itself each time there's a change in the sheet. So effectively, your NOW() function gets updated whenever there is an event (a few defined events that is) on the sheet/workbook.

[peter renton]

Thank you for the code, it looks a lot better now :-)

I will try the now() to see how it works but what triggers the update? as the sheet may stay dormant for some time and the count down time still need to work?

Peter

[Excel Fox]

The count down can only work using a VBA based timer that fires at periodic intervals. For that, you'll need to run a macro from the moment the workbook opens, till the time it closes.