Excel Formula Please! Help Me!

[joy.sims]

I have an excel spreadsheet that is computing time for a
deadline with a yes or no response. If the deadline time
is not met the computation does not work the way I want it
too. How do I write a formula that will give me a no
response if the actual time moves to the next day and is
after my deadline.

May 3 May 4
Deadline Actual Time Deadline Made
10:30 PM 12:00 AM Yes (This should read no)

=If(F33>c33,"no","yes")
This is the current formula in the deadline made column.

Please help me. Thanks so much in advance.
Joy

 

[Manish Bajpai]

Your formula is correct, you just need to change the time
format to "Date & Time format". It will look like this :

5/25/04 22:30 5/25/04 0:00 YES

Thanks,

Manish

 

[Frank Kabel]

Hi
how are your date values 'May 3' entered. Are these real Excel dates?
If yes you could use
=If((F31+F33)>(C31+c33),"no","yes")