anaylze a log file

Hi all,

Please show me a better way...
I am trying to produce a line chart from a log file containing usage
information.


The log file is build up like this: (and so is my input table in excel)

username | start datetime | end datetime
John | 8:35 | 9:30
Doe | 8:05 | 8:30

The resulting line chart should show the number of simultanious users
in the system (Yaxis) in a timeline (Xaxis).


At this stage I already created a solution, but it is dirty and even
involves VBA to writeout the logfile into an easier format like:

username | WasLoggedOnThisHour
John | 8:00
John | 9:00
Doe | 8:00
Thus diverting from MY issue that the original log uses time-ranges
instead of specific time-stamps.


I just wondered if it would be possible to use the original log format
and create the line chart with some specific excel functionality I
might be missing.

thanks for your help!