P
pcreyght
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!
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!