So I've been wrecking my brains on how to get around this problem, but I can't come up with the answer.

Here is my formula:

//[Now] - changes to Now() every 30 minutes using table to table sync

//[Store Start Date] and [Store End Date] come from a related table

var date nowDate =ToDate([Now]);

If([Store End Date]>=($nowDate) and

[Store Start Date]<=($nowDate) and

Abs([Store End Time]-ToTimeOfDay([Now]))<=Hours(1),

true,false)