Seeing whether a time period is between a range of time

[Mzhukov]

Excel woes. I have a head ache trying to work this out and require some trickery assistance.

I have two date/time fields say;

01/02/12 12:00am and 01/02/12 13:34pm

I need to work out, over these two fields whether there is a four hour (or more) period between 00:00 and 08:00 and bring back a postive response. So in this example it would be where as;

01/02/12 06:30am and 01/02/12 11:30am doesn't

Can any one assist?

[Pepe Le Mokko]

Hi

perhaps this link will put you on track?