Excel Formula Requested - Please, please help me!

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

joy.sims

This would require me to rebuild 12 spreadsheets all with
32 pages each. Is there another way? Also, I tried this
response in one cell and it didn't change. I don't know
why. Can you think of any other way?

Thanks again in advance for your help.
 
Joy

if you only have the time in the cells then 12:00 AM (F33) is less (earlier)
than 10:30 PM (C33) hence
=IF(F33>C33,"no","yes") will return "yes".

If, as it appears, the date is in the cell two rows above the time, you
could try this instead:

=IF(F31&F33>C31&C33,"no","yes") which returned "no" in my testing

Regards

Trevor
 
Back
Top