Help with query to do with date and time


I am using telegraf to pull the modified date into InfluxDB, it works fine with my test. I need to find a way in Grafana to show the hours since the file was last modified now as an extra column, can this be achieved in Grafana?

Here you can see my query and time of file when it was last updated. I’d like to find a way to add another column to show how many hours since it was last modified.

Grafana Version 10.