How to apply a local time offset to UTC time
How to Apply your own UTC channel in VBOX Tools with an offset.
B = UTC Time
YQ = Offset channel - either create a channel for the hours offset and substitute for YQ, or just simply replace YQ with the hour offset required.
| B+(YQ*10000)-(240000*h(B+(YQ*10000)-240000))+(h(B+(YQ*10000))-1)*(-240000) |
Note: h() is the Heaviside function – the output is 0 if the input is < 0 and 1 if the input is >= 0.