Forum Discussion
@Pivot Table and analysis of weather data
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.
monicard01 Glad I could help. Simplicity is my middle name :)) Keep in mind that dates and times ar just numbers in Excel, but formatted in a particular way.
Hmm...I just did the same thing, but all I get is the low temperature for the month. How can I select each date? My row labels only show month.