Monthly percentage greater than a value

  • Thread starter Thread starter eidde1
  • Start date Start date
E

eidde1

Hi all
I have a spreadsheet with nearly 19,000 rows of data. It contains turnaround times in hours for two years of laboratory data. Col J is the turnaround time in hours and Col D is sample date. I would like to work out monthly percentages of turnaround times > 4 hours (which is the target TAT). Any helpwith this would be greatly appreciated.

Thanks
Eddie
 
Hi all

I have a spreadsheet with nearly 19,000 rows of data. It contains turnaround times in hours for two years of laboratory data. Col J is the turnaround time in hours and Col D is sample date. I would like to work out monthly percentages of turnaround times > 4 hours (which is the target TAT). Any help with this would be greatly appreciated.



Thanks

Eddie
Click to expand...

Sorted this with a pivot table in the end. Thanks
 
Back
Top