Nov 07 2020 10:30 AM - edited Nov 07 2020 10:59 AM
Nov 07 2020 10:36 AM
I know I don't know anything (Socrates)
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Nov 07 2020 11:00 AM
Nov 07 2020 11:20 AM
When the admission hour is between 10:00 PM and 5:00 AM ... what should happen here?
Excel is from the Arabic or Hebrew region.
From right to left.
In your Excel sheet you only have these lines
entering hour |
22:00:00 |
19:00:00 |
23:15:00 |
06:00:00 |
04:15:00 |
... what should become of them?
... and as already written, please state the Excel version and operating system,
if possible exactly (e.g. Excel 365 Pro or Win10-2004).
Forgive us for the circumstances, but if no precise task can be set and no precise instructions can be given, then in the best case, only an imprecise solution can be suggested to you.
Thanks for your patience and understanding
Nikolino
I know I don't know anything (Socrates)
Nov 07 2020 11:35 AM
Nov 07 2020 11:42 AM
Nov 07 2020 11:59 AM
Thanks!
1. Is ">--" means after and "<--" before?
2. Will it work in other formulas?
3. The option you suggested does not count the exact time 22:00:00 in the range,
Is there a way to include it in (like "=>" in math)?
Thanks again!
Nov 07 2020 12:27 PM
< means smaller than, > means greater than and -- is a type conversion from text to number because the time is set in double quotes which means Excel regards it as text.
If you want to include the lower and upper boundaries change < to <= and > to >=.
Nov 07 2020 12:53 PM
Nov 07 2020 01:42 PM
Nov 07 2020 02:09 PM
Nov 07 2020 02:13 PM
Nov 07 2020 02:53 PM
Nov 07 2020 03:27 PM
Nov 07 2020 05:06 PM
And here we are with a totally different problem.
=((1-MAX(B5,22/24))+(MIN(C5,5/24)-1)+(C5<B5))>=2/24
Nov 08 2020 05:27 AM
Since I have a great weakness for the Hebrew culture, please allow me and everyone else involved to add my thoughts.
Everything in the file, maybe it will help you to develop your project further.
Hope my thoughts in the file fits into your project.
Thank you for your patience and time.
Wish you a nice day / night with lots of health, joy and love.
Nikolino
I know I don't know anything (Socrates)
Nov 08 2020 09:49 AM
It only to be adjusted to night shifts like start 01:00 and end 08:00