View Single Post
 
Old 09-20-2017, 02:54 AM
Nhill Nhill is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2017
Posts: 1
Nhill is on a distinguished road
Default how to get excel to recognize dates

Hi

I have a dataset running from 11 am the 23rd of Juli to 11 am the 24th of juli the data is collected every minute, so it goes without saying many of the time stamps are the same for the 23rd and 24th so when I try to plot the data time on x axis flow on y axis it cannot recognize that it is two different dates and thus two different times and should not be plotted the same place - how do I overcome this problem?
Reply With Quote