Don't forget that you can put code in the SQL query window and try different things.
This little snippet will help you, I think.
declare @in_time TIME;
set @in_time = CONVERT(TIME, '08:17:00');
select IIF(@in_time > CONVERT(TIME, '08:15:00'), 'late', 'on time');
go;