L
Legacy 272348
Guest
I am working on an application that records jobs on a helpdesk as the job is added to, i.e. when the administrator updates it or closes it for example, it creates another line (which comes out into excel as an entry or row in the spreadsheet). Some jobs can have 7/8 lines some can have 3. At the moment I've got 800+ jobs which account for about 4000 lines on my spreadsheet, my difficulty is manipulating the data because of the varying lines (all the jobs have a common job no. next to them) - I'd like to get length job is open, length job is taken to close (each line has a date / time next to it) but because the number of lines per job varies I don't know how to do it in the spreadsheet or a pivot.
Any ideas / urgent help please?
Any ideas / urgent help please?