Pivot Table is this the right direction? Or maybe Array?

Sam40mUK · Mar 19th, 2002, 03:21 PM

Hello All,
I have a problem, however when I have tried to get to grips with the PT it seems to get very complex!
I have say a single Project with hours worked on specific days for a particular trade, these hours are split between Normal, Time+Half, Double Time (in seperate columns).
I was hopeful of producing a PT ultimately detailing ..by Trade, Total Normal Hours, Time+Half Hours, Double Time Hours against the Project.
Is this possible and are PTs the best way of going about it or would I be better considering an Array option?
Thanking you in advance.
Sam

[ This Message was edited by: Sam40mUK on 2002-03-19 14:32 ]

[ This Message was edited by: Sam40mUK on 2002-03-19 15:56 ]

Chris Davison · Mar 20th, 2002, 04:01 PM

Hi Sam,

not being able to see the specific data, but yeah, sounds like a job for pivot tables.....

what was going wrong ?

hope this reassures you a little,
Chris

ps...hope Wrexham don't go down

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 03:21 PM	#1
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Hello All, I have a problem, however when I have tried to get to grips with the PT it seems to get very complex! I have say a single Project with hours worked on specific days for a particular trade, these hours are split between Normal, Time+Half, Double Time (in seperate columns). I was hopeful of producing a PT ultimately detailing ..by Trade, Total Normal Hours, Time+Half Hours, Double Time Hours against the Project. Is this possible and are PTs the best way of going about it or would I be better considering an Array option? Thanking you in advance. Sam [ This Message was edited by: Sam40mUK on 2002-03-19 14:32 ] [ This Message was edited by: Sam40mUK on 2002-03-19 15:56 ]

Mar 20th, 2002, 04:01 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi Sam, not being able to see the specific data, but yeah, sounds like a job for pivot tables..... what was going wrong ? hope this reassures you a little, Chris ps...hope Wrexham don't go down