$$Excel-Macros$$ Re: Pivottables and Pivot Charts and target line

. On Dec 2, 8:24 pm, Droidy <[EMAIL PROTECTED]> wrote: > I have a spreadsheet exported from Access that contains a list of jobs > and the time taken to complete each job. > I have created a pivottable that gives

$$Excel-Macros$$ Pivottables and Pivot Charts and target line

I have a spreadsheet exported from Access that contains a list of jobs and the time taken to complete each job. I have created a pivottable that gives me the average time taken over each weekly period. Based on that pivottable I have a pivotchart. What I would like to do is display a target line o

$$Excel-Macros$$ Retaining formats when using Text to columns

I have a spreadsheet with a column of data that contains a date and time, I want to split the time into a separate column but retain the format of the time as 24 hour clock. The reason being is I want to create a histogram using the data analysis Add-In to show how many items were created between