Hi

I use Excel 2K

In cell F13 i have:-

27/06/2009 7:00:00 PM

In cell G13 I would like a formula that says that if G13 is greater than or
eqaul to 27/06/2009 7:00:00 PM and less than 27/06/2009 7:00:00 AM then
"NIGHT"

or

If G13 is greater than or equal to 27/06/2009 7:00:00 AM and greater than
less than 27/06/2009 7:00:00 PM then "DAY"


We run the business on a 24 hour clock

Example

DAY SHIFT = 700 hrs to 1900 hrs
NIGHT SHIFT 1900 hrs to 700 hrs

I need a cell that displays if it is NIGHT or DAY

Hope I have explained myself

Thanks

John