Forum Discussion
@Pivot Table and analysis of weather data
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.
monicard01 Did you group by day? (Screenshot taken on a Mac, but similar on a PC)
Otherwise, upload part of your file, say the first 200 rows only, with your pivot table.