This is the sample data in a more usable format:
CREATE TABLE dbo.Example
(
[User] VARCHAR(50) NOT NULL,
[Action] VARCHAR(10) NOT NULL,
[DateTime] DATETIME NOT NULL
);
GO
INSERT dbo.Example
([User], [Action], [DateTime])
VALUES
('Smith', 'inserted', '2010-07-22 08:33'),
('Andy', 'inserted', '2010-07-22 09:40'),
('Steve', 'collected', '2010-07-22 10:01'),
('Smith', 'Update', '2010-07-22 10:05'),
('Scott', 'inserted', '2010-07-22 10:10'),
('Paul', 'inserted', '2010-07-22 10:30'),
('Smith', 'collected', '2010-07-22 10:45'),
('Smith', 'collected', '2010-07-22 10:50'),
('Smith', 'deleted', '2010-07-22 11:15'),
('Smith', 'inserted', '2010-07-22 12:15');
The sample output is missing values for the time difference, and explanation doesn't go into enough detail for me to guess what you are after.