Hi there I'm an undergrad using Excel for Mac 2011 working in a university lab and am having lots of trouble trying to calculate what fraction of each hour a fish spends in a certain swim chamber.
I have been able to calculate the proportion per hour using Pivot tables and it's working alright...