Time worked in a given time range

I want to report on time worked in a given time range. Think billing out for time spent working on tickets.

I’ve got a saved search in the dashboard, and I added the time worked query. However I can’t seem to find a way to have the query update with the time that the dashboard interval is on. Does anyone know how to do this? Or achieve this report with another method?