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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac