I’m a bit stuck!
I have two time values (in Google Sheets they appear as time, 07:00, plus they can be a value (0.x)
- this is opening and closing hours in utc
I have a computed column in my lookup sheet that uses XC for getting UTC - as a date time value (date + time)
I’m stuck on doing my if-then-else on just the time part of the utc / now.
Any help, please? Thanks!