Excel Formula Requested - Please, please help me!

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.
 
T

Trevor Shuttleworth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top