Forum Discussion
incorrect formulation
NikolinoDE I didn't see any change in your conditional formatting formula. I implemented the last suggestion I made in the attached sheet and added more so it will check what day it is and auto-index down on the Jan sheet so 1 conditional formatting formula will work for every day in that month (I added the 2nd to the range and leave it to you to add the rest). You still need to tweak the formula for each category (MA1, MA2, etc...) since each needs its own color.
I also changed the formula to >= the start time but < end time because the don't actually work that hour/ half-hour period.
I also noted and corrected that your 1st 06:00am was actually 06:00am the next day and your 06:00am at the end was 05:59.999999999am (floating point error). You may want to look at the rest of the times and days for those and similar errors also.
- Hello Sergei Baklan,
thx for your quick response.
I open the sheet and try to insert in G 3 and H3 time like 23:00 in G3 and 04:00 in H3 and not works...am i making a mistake somewhere?
Thx
NikolinoNikolinoDE I think you are having a problem with the next day roll over. If you want to treat 03:00am as a continuation from the previous day you have to enter it as a day after the prior 22:00 (if you look at SergeiBaklan sheet, he entered H3 as 27/24 or 3hrs more than a full day). If you don't want to have to do that every time and you know that column H will always have a time in the next day you can +1 in the formula or you can change row 7 to make it all the "same day" and use an OR condition >22:00 OR <03:00 as long as you are consistent. If you don't know that H will always be the "next day" then you need to add additional condition to first check for that.
- How should the formula look like that you enter the time in H3 and appear in the timeline, even if the end time is less than the start time?
In the end, I would like to enter the times from C3 to H6 (see picture at the beginning) and they should appear automatically in the timeline ... also, as I said, if the end time is less than the start time.
Thx
Nikolino
