I need to quickly figure the 9th and 20th business days of each month for the rest of 2012 and all of 2013. Preferably not in a manual fashion. [more inside]
posted by reenum on Sep 14, 2012 - 6 answers

Excel help needed in calculating times. I need to calculate and predict times based on fixed distances and a known average speed. [more inside]
posted by dg on Jun 28, 2011 - 8 answers

Excelfilter: Okay, I'm confident that this can be done in Excel, but I don't know how. Basically, I have a set of samples for which a value (size) was measured at various days. I need some formulas to tell me when the first and last values were measured and what those values were (for each sample). [more inside]
posted by kisch mokusch on May 26, 2010 - 9 answers

If I'm looking at existing statistical data, how do I try to find a correlation between two variables over time? Scatterplots have confused me, because they don't seem to reflect the passage of time, but just where x and y meet. Pearson's r doesn't seem to do it either w/r/t time. [more inside]
posted by trondant on Dec 11, 2007 - 13 answers

Looking for an Excel template to track children's time (billable hours) over a month. [more inside]
posted by OlderThanTOS on Oct 9, 2007 - 6 answers

Excel Filter: How do I calculate average speed with a start and end time? [more inside]
posted by bytewrite on Jun 6, 2007 - 7 answers

Excel question on charting time - how to make it appear relative, not absolute? [more inside]
posted by ObscureReferenceMan on Nov 6, 2006 - 5 answers

MS Excel: How do I convert a number representing seconds into minutes:seconds? [more inside]
posted by contessa on Apr 3, 2006 - 13 answers