Welcome to the forum. Check out the thread below along with the other links in it and see if that helps. Essentially, you'l group by your states, and sum the timestamp difference between the current row and the previous row using a lag() window function most likely.
Calculating Total Time in Seconds - Ignition - Inductive Automation Forum