SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

drop table if exists Attndate;

create table Attndate
(EMPCODE     int
,EMPNAME     varchar(30)
,[DATE]      date
,InTime      time
,LateMins    int);

insert into AttnDate (EMPCODE, EMPNAME,[DATE],InTime,LateMins) values
(1,'John' ,'08/01/2017','9:17', 7),
(2,'David','08/01/2017','9:18', 8),
(3,'Kumar','08/01/2017','9:12', 2),
(4,'Jack' ,'08/01/2017','9:18', 8),

(1,'John' ,'08/26/2017','9:27',17),
(2,'David','08/26/2017','9:20',10),
(3,'Kumar','08/26/2017','9:17', 7),
(4,'Jack' ,'08/26/2017','9:13', 3),

(5,'Rose' ,'08/28/2017','9:31',21),

(2,'David','08/29/2017','9:28',18),

(3,'Kumar','08/30/2017','9:23',23),

(4,'Jack' ,'08/31/2017','9:59',49),

(1,'John' ,'09/01/2017','9:30',20),
(2,'David','09/01/2017','9:25',15),
(3,'Kumar','09/01/2017','9:12', 2),
(4,'Jack' ,'09/01/2017','9:15', 5),

(5,'Rose' ,'09/02/2017','9:36',26),
(2,'David','09/02/2017','9:18', 8),
(3,'Kumar','09/02/2017','9:13', 3),
(4,'Jack' ,'09/02/2017','9:51',41),

(1,'John' ,'09/03/2017','9:30', 4),
(3,'Kumar','09/03/2017','9:30',13);

22 rows affected

EMPCODE	EMPNAME	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Total Late Mins
1	John	27	null	4	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	17	null	null	null	null	null	48
2	David	23	8	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	10	null	null	18	null	null	59
3	Kumar	4	3	13	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	7	null	null	null	23	null	50
4	Jack	13	41	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	3	null	null	null	null	49	106
5	Rose	null	26	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	21	null	null	null	47