The works fish will be left for a fortnight, should we leave the tank light on or off?

The best choice is to get a timer from a local hardware store. This will turn the light on and off for you. Other than that it is better to leave off then on.