How to use relative time option to show shift data

Hello everyone,

I have requirement where I need to show data from 3 shift that employees work in:

  1. Shift 1 (00:00 → 08:00)
  2. Shift 2 (08:00 → 16:00)
  3. Shift 3 (16:00 → 00:00)

I know that I can use Relative Time option in Query Options to set from time for specific panel. But I am not able to make out exact configuration for my requirement. Could someone please point me in right direction ?

Thanks