Ecxel help

  dobie2 20:34 01 Feb 2011
Locked

Hi Guys

Looking for an Excel formula which will give a pass or fail result between two dates and times.

For example.

Cell B1 = 30/Apr/2010 12:19
Cell C1 = 30/Apr/2010 12:37

If the time diffarance is greater than 15 minutes cell D1 says "Fail", if less, "Pass".

This also has to work with dates and times either side of midnight.

Thanks in advance

Debs.

  Simsy 22:38 01 Feb 2011

that the cells concerned do actually contain the date as well as the time, then there is no need to worry about the "crossing midnight"

If that's really the case, (ie date and time in the same cell), the following will work;

=IF(C1-B1>0.25/24,"Fail","Pass")

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?