I just tried walking through the steps part by part and I see what @RJ_Marcus was referring to. It looks like the resulting %BeforeAlarm variable was being stored in scientific notation which didn’t work with the time profile.
If you take his suggestion and wrap the variable formula in round() it keeps the time as a normal integer timestamp which works with the profile:
round(%TIMES+%seconds-(%mins_before*60))
I’ll update the text in the original post above accordingly. 