Excel Magic Trick 1469: Add Daily Rainfall 5 AM to 5 AM Next Day: Helper Column & PivotTable

Download Files: http://ift.tt/2iF8Tie
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period.
Topics:
1. (00:11) Introduction to data set and the task at hand
2. (01:30) Look at Time Values and determine what Time Value should be subtracted from each Date-Time to get correct category.
3. (03:32) Add Data Validation List to Time Cell so we only subtract the correct whole hour.
4. (04:55) Helper Column Formula to subtract hour amount. See Relative Cell References and Absolute Cell Reference. See the INT Function.
5. (06:47) Create PivotTable
6. (08:05) What happens if we change Number of Hours to Subtract? PivotTable MUST be refreshed
7. (08:35) Summary
Related Videos:
Excel Magic Trick 1470: Add Daily Rainfall 5 AM to 5 AM Next Day: Power Query
Excel Magic Trick 1471: Add Daily Rainfall 5 AM to 5 AM Next Day: Array Formula (Most Automatic)

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.