Posts by johnny001

Thanx for your help Brandtrock.
I looked through the data, and it seems the pivot table is not correct in the totals field.
i.e. for station 16.08.01 it should be 20 days, not 13

Also, regarding the new formatting, looks simple enough to do, however I have over 6000 entries for which i'd have to apply this new formatting to.

I am thus thinking maybe it should be somehow done by formulas? To simply this process, I am now only looking for summarys by workstation.

So ideally, for each workstation, I would be able to look at how many days it was used.
Any ideas?

thx

johnny

Hello

I have been working on sorting through loads of data, and fianlly i have it down to manageable size. I am now focusing on 3 columns:

-A: this is a location of the workstation, it is a series of numbers separated by dots, ie. 16.05, 16.54.87 and so on
-B This is the name of the staff that was located at the workstation
-C The length of the booking for each person at each workstation

Now the formating of this file may seem strange, but it is due to the way it was extracted from Lotus. Now for what I need:

I have to summarize the amount of time spent by:
1) workstation
2) Person

So the output column(s) should look something like this:
for 1)
16.05 20 days
16.08.01 18 days

for 2) Jane Smith 20 days
Bob Dole 4 Days

Any help would be much appreciated, as I have yet to figure out how to start this out. ( when i tried pivot table, it won't let me create it due to an error message regarding pivottable name).

I have attached a sample file for a better explanation

Thanks

Johnny