T-SQL query to use with SSMS SQL 2012 Server

Need a sql query, which can be run in ssms, to produce the output as illustrated in the attached spreadsheet breakouts. I have included a text file with the script to create the sampled data as well as the outcome spreadsheet illustration. The scenario: Multiple mail clerks deliver mail throughout our campus. We have begin locating them by RFID When they are at any workstation, our application stores: The Mail clerk's ID The workstation identifier a date-time stamp Example MailClerk 1 arrives at workstation 1 at 10:00am and he stays until 10:05 am at that workstation Our data table would receive approximately 3 record inserts, as follows, HitID 001 MailClerkID: 1 WorkStation:1 DateTmeOfHit: 10:00 HitID 004 MailClerkID:1 WorkStation:1 DateTimeOfHit: 10:02 HitID 007 MailClerkID:1 WorkStation:1 DateTimeOfHit: 10:05 HitID 011 MailClerkID:1 WorkStation:2 DateTimeOfHit: 10:08 At HitID 011 - he has moved to a different workstation, but for Hits001 through Hits007, he was at the SAME STATION, and that is the blocks-of-time-at-same-station we are looking for. The attached spreadsheet has worksheets for the raw source data, a breakout by 3 different mail clerks, the color-coded blocks of time at each mail station for these 3 clerks, and the [DesiredReportOutput] worksheet. IMPORTANT: the data in the table in the DESIREDREPORTOUTPUT table is the ONLY output WE NEED