Below is a quick script to convert the run_duration column into 3 separate columns for Hours, Minutes, and seconds. The script will also convert the run_date column to a date. Useful for dropping into Excel and running reports.
runDate = CONVERT (DATETIME, RTRIM(run_date)),
run_duration/10000 Hours, --hours
run_duration/100%100 Minutes, --minutes
run_duration%100 Seconds --seconds
Just add a job_id in your where clause if you want to track a single job. I used this script to generate a report of run times for a specific job. We had a SQL job run long (so we thought) and wanted to drill into the numbers a bit. After some investigation we discovered that the job was pretty consistent and that the long run time was consistent with the job history.
You can also just combine the hours, minutes, and seconds into 1 column like so:
runDate = CONVERT (DATETIME, RTRIM(run_date)),CAST(run_duration/10000 as varchar) + ':' + CAST(run_duration/100%100 as varchar) + ':' + CAST(run_duration%100 as varchar)