Thank you Hui, that's almost perfect for what I need. I'm trying to make my sheet as dummy proof as possible, so people can populate that table and the spreadsheet will spit out a daily average.
Is there a way that I can make this dynamically update? I've considered using a separate table...
Hi, I'm currently trying to create a sum of event times from a table with a variable number of entries per day. eg.
Day Events Minutes
1/05/2012 dog ran away 10
1/05/2012 explosion 20
2/05/2012 production halt 45
3/05/2012 grocery shortage 15
4/05/2012...