Menu
Our Excel data includes timestamps readings every 30 minutes, and we want to be able to group this in Pivots later on to identify each reading and determine which Year, which Month, which Week etc.
This is done with standard Excel functions like “=Year()”, “=Month()”, “=ISOWeeknum()”, “=Weekday()”, “=Hour()”.
Each reading of the weather data includes the Date & Time of the reading and anyone who has made reports know that reports often have to be made per Year, per Month and so forth.
So in order to make that possible later on, we first add some extra data columns for these time intervals and we use formulas to get the information based on the Date/Time which we do have.
This lesson shows you how we add those new columns and write the formulas to get the information we want.
