You need to define when day ends and night begins and when night ends and
day begins

Or, are you simply going by AM/PM ?


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
You need to define when day ends and night begins and when night ends and
day begins.

--
Biff
Microsoft Excel MVP


"kbee" wrote in message
...
cell a1=1/1/08 08:00:00 AM, cell a2= 1/1/08 22:00:00 PM
cell b1 or b2= day/night
what should be the syntax?
thanks to anyone who can help with this.