I have two string variables that I need to subtract to find their times, and need some help with the syntax please.
DECLARE @S1 varchar(10) = '09:15 AM'
DECLARE @S2 varchar(10) = '10:15 AM'
DECLARE @S3 int
set @S3 = @s1 - @s2
select @s3 -- would like the answer to be 60 (minutes).