Forum Discussion
@Pivot Table and analysis of weather data
monicard01 Perhaps like in the attached (simplified) example?
Not sure what you mean by "highest low temperature", though. I assumed you wanted the lowest temperature on any given day and used "Min." in the value field. Use "Max." if you really want the highest (i.e. warmest) of all the low temperatures.
That seems to work. I wanted to find out which days had the highest minimum temperature. How do you concatenate the date and time fields together?
monicard01 In my example I just entered date and time into one cell. But if you have date and time in two different cells, make sure that they are formatted as date and time respectively. Then you can create a time stamp by adding the two together and apply a custom format " dd/mm/yyyy hh:mm ". See attached.
Oh my...That simple. I was trying concatenate among other things. Thanks for clarifying and I appreciate the help.
