Solved comparing to dates and times within a timeframe

August 3, 2012 at 14:05:43
Specs: Windows XP
First off I have no idea what i'm doing just want to make a large task seem a little smaller

I have four columns with dates and times A2: Start date B2: Start time C2: Completion date D2 Completion time. In E i would like to compare the start date&time(A2&B2) with the completion date&time(C2&D2) to make sure it is completed within 72 hrs. If it is not completed within 72 hrs I would like an "N" place in column E. How would I got about accomplishing this?

See More: comparing to dates and times within a timeframe

Report •

August 4, 2012 at 12:48:07
✔ Best Answer
Try this:

In cell E2 enter the formula:


If the time is greater than or equal to 72 hours
you should get the TEXT string NO otherwise the cell remains blank.

See how that works.


Report •
Related Solutions

Ask Question