[mythtv-users] power search with maths (program duration)

[Tim Draper]

I'm trying to setup a power search to only record the 1hour showings of a program. having taken a look in at the db via phpmyadmin, there does not appear to be a specific column with duration. I assume to calculate the duration, i need to subtract 'starttime' from 'endtime' from the program table.

This is where i have issues. Not being familiar with sql or building queries, how would i do this?

thanks