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?

To get time to register it, use Now function, which returns a date AND time.

In Excel, a date is integer (the number of days at 01.01.1900 00:00:00), and time is decimal part of day. I.e. 1 hour equals 1/24, 1 minute equals 1/(24*60) etc. P.e. I read current time in excel, using NOW() worksheet function, and in General format it was 42998.5644840278