Excel Formula Please! Help Me!

  • Thread starter Thread starter joy.sims
  • Start date Start date
J

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
 
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
 
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")
 
Back
Top