Selection Box??

Posted by Cameron on April 20, 2001 8:52 AM

Well I have a cell, call it A1. And if it's daylight I want the value to be 30 (minutes), and if it's night I want the value to be 45 (minutes.

and if function with current time won't work since this is for future planning. How would I insert a selection box?

Posted by Dave Hawley on April 20, 2001 9:01 AM

Hi cameron

Try this: =IF(NOW()>0.75,TIME(0,45,0),TIME(0,30,0))

and format the cell as hh:mm:ss

Dave

OzGrid Business Applications