Ecxel help

  dobie2 20:34 01 Feb 11
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 11

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…