Try this script, it states the start and end timestamp of each DB backup
USE [msdb]
GO
SELECTrs.[destination_database_name],
rs.[restore_date],
bs.[backup_start_date],
bs.[backup_finish_date],
bs.[database_name] AS [source_database_name],
bmf.[physical_device_name] AS [backup_file_used_for_restore]
FROM[dbo].[restorehistory] rs
JOIN[dbo].[backupset] bs
ON rs.[backup_set_id] = bs.[backup_set_id]
JOIN[dbo].[backupmediafamily] bmf
ON bs.[media_set_id] = bmf.[media_set_id]
ORDER BY rs.[restore_date]...