how to use pivot for this task

Question

i have a table like below

attdate	intime	outtime
03-01-17	08:45	18:00
03-02-17	08:45	20:00

my expected result is

1	2	3
p	p	ab