I would take your two dates (publish and hide). Create two math columns that calculate `FLOOR(Now - Publish) + Publish`

. Do the same for Hide. I don’t know if this is exactly correct, but the goal is to get a date that’s equal to today but with the time you set.

Next create two more math columns that calculate `FLOOR(Now - Publish) + Publish + 1`

. Do the same for Hide. Here the goal is to get a date that’s equal to tomorrow but with the time you set.

Now create two IF THEN columns that will compare the dates.

First one to compare if the calculated Hide date (for today) is before Now, then return calculated Publish date for tomorrow, else return the calculated Publish date for today.

Your second IF Then will compare if the calculated Hide date (for today) is before Now, then return the calculated Hide date for tomorrow, else return the calculated Hide date for today.

Disclaimer: I haven’t tested this, so it may not be exact instructions, but should give you an idea of what needs to be done.