The following formats the duration in HH:MI:SS.

CONVERT( VARCHAR(8), DATEADD( SECOND, DATEDIFF( second, s.backup_start_date, s.backup_finish_date ), 0 ), 114 )