Good morning,
i was wondering if anyone can help please, I am trying to put "OOH" into cell C1, when the time cell C15 is >17:00:00 <08:00:00. I have tried the IF command and it continously tells me I have an error.
Many thanks
Robbosan
Good morning,
i was wondering if anyone can help please, I am trying to put "OOH" into cell C1, when the time cell C15 is >17:00:00 <08:00:00. I have tried the IF command and it continously tells me I have an error.
Many thanks
Robbosan
How can a time is greater than Evening 5:00 and less than Morning 8:00
Do you mean .. next day Morning 8:00
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Oops! ...
You beat me to the change Josie
Formula:Please Login or Register to view this content.
Last edited by Marcol; 07-17-2013 at 08:04 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
I reckon you mean OR rather than AND ;-)
Josie
if at first you don't succeed try doing it the way your wife told you to
Yes sorry not used to working with 24hr clocks
Thank you very much that works great.
Robbosan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks